Queries, Reports and Forms, oh my!

[emcc]

I have a form (for prospects) based on a table. The table, for the most part, will be populated from our website. But, there will be times information will have to be manually input. What I would like to have is a list of prospects pop up and then be able to choose from the list and have the form open up with that prospect's info.

I have created the form. I have also created a report which is based on a query which includes just the prospect name and organization. I'm not sure how to make it all work together or even if I'm working in the right direction.

Should the record source of my form be the report, the query or the original table?

I'm lost....can anyone point me in the right direction!

Thanks in advance.

 

[Rich_Lovina]

I have been working on a similar problem, and conclude the form is best left just for manual entries, whilst the query is the more effective path for your reports.

 

[Flea]

You can do this, if I understand correctly by having a drop down or combo box with the row source with "SELECT prospectname FROM ProspectTable".

Then on the afterupdate action do a DoCmd.ApplyFilter , "[ProspectName] = Forms![yourForm]![lstBox]"

This should allow you to have manual input.