Form Bound to Query problems

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Christian ><> - 06 Jun 2006 14:49 GMT

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?

Reply to this Message

jahoobob - 06 Jun 2006 15:24 GMT

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.

>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?

Reply to this Message

Christian ><> - 06 Jun 2006 15:44 GMT

>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.

Reply to this Message