Report based on a form

[hrseebeck]

Hi! I'm not new to Access but I am running into some difficulty when trying to get a report to show what I want. Here is what I am trying to do. I need to have a form where a sales person enters data (ie-quote) with potential client & product information. Right now the salesperson enters the client name (from a look up box) and the address fields are automatically updated with the info based on the customer table. The product is set up the same way where the sales person selects the product and the description & price automatically fill in from the products table.

I would like to use this same data in a report but when I try to create a query with all the necessary fields that are autopicked, no records are being returned and therefore my report is showing blank.

Is there a way to make this work or am I going about it all wrong?

Thank you!

 

[Beetle]

Hard to give you an answer without knowing more about your db. Those controls (text boxes) on your form(s) that are filled in when the selection is made in the combo box could be bound to fields, or they could be unbound calculated controls, which may or may not be contributing to the issue.

Also, the type of joins you are using in your query is important as well. If you're not sure of the answers to these questions then uploading a copy of your db with a few bogus records may help us to see what you've got going on there.

 

[Pat Hartman]

Have you tried using the form's RecordSource query in the report's RecordSource property? When you open the report, you can send it the ID of the record currently being displayed on the form.

 

[hrseebeck]

Thank you for your help. I have attached a zip file of a dummy database.

 

[Pat Hartman]

Well, did you try it or am I supposed to do it for you?