Form Bound to Query problems

[Guest]

OK, I've got my form bound to a Query. My pulldowns don't work when I'm
entering the form. They are blank. When I open the query and enter data,
they work, but not when I'm inputting into a new form...

Should I make the control source the original table for those instead of the
query? If I do that, how can I do the auto complete stuff?

 

[jahoobob via AccessMonster.com]

Do you have these fields as lookup fields in the table? You shouldn't if you
are going to do a lookup in a form to enter data in these fields. Is your
form bound to the query upon which the dropdowns are based? It shouldn't be.
Tell us the names of the tables, queries, and forms involved and maybe we can
help.

 

[Guest]

Do you have these fields as lookup fields in the table? You shouldn't if
you are going to do a lookup in a form to enter data in these fields.

Yes, I do. I did this in order to establish the relationship when I created
the tables.

Is your form bound to the query upon which the dropdowns are based? It shouldn't be.

Yes, that’s what instructions for having the AutoLookup query said I should
do. And that part works…

Tell us the names of the tables, queries, and forms involved and maybe we can help.

Tables:
Job Work Orders Table (This is the table that links everything)
Customers Table
Customer Contacts Table
Project Managers Table
Insurance Companies Table
Insurance Contacts Table

Queries:
Job Work Order AutoLookup Query

Forms:
Job Work Order Form


I got them to work… But I’m not sure if what I did is correct yet. When I
look at the Properties of the Combo Boxes that are blank, the Row Source is
blank. I set the original field in the table as the Row Source and now they
work like they are supposed to.