Auto Lookup Auto fill

[Pamala Combs via AccessMonster.com]

I am trying to create a form with 3 auto fill auto lookup spots. Carrier,
Consignor and Consignee. I want the address info for each to auto fill on
entering their unigue ID number. I have tables for each, with
corresponding select queries, with one-many relationships for each to
another table with shipping information. I've also created the appicable
combo boxes for Carrier, Consignor and Consignee IDs in each table.
However, when I run the form wizard it tells me it can't create my form, it
doesn't tell me why.

What am I missing?

 

[Michel Walsh]

Hi,

You can't create *any* form? if so, your database is probably locked
against new addition of code or of Access objects. Try to close the
application, and check if there is no dot-ldb file with the same name (if
so, delete or rename it).


Hoping it may help,
Vanderghast, Access MVP

 

[Pamala Combs via AccessMonster.com]

I can create a form using just one table, but when I try to pull in the
tables needed for the auto-lookup auto fill, it says "the wizard is unable
to create your form"

 

[Michel Walsh]

Hi,


If the form exists and you wish to add a combo box to it, have the
Control-Wizard active, not the Form-Wizard, and create the combo box.

If you wish to get the display of many fields from two tables in a
single form, first build a query that makes the appropriate JOIN between the
tables and save that query. Next, create the form on that query, rather than
on one of the initial table.

You have another scenario in mind?


Hoping it may help,
Vanderghast, Access MVP

 

[Pamala Combs via AccessMonster.com]

I tried that and while Access created the form based on the query, it
didn't auto-fill the data. I've since talked to someone else and she tells
me that Access 2000 has a problem in this area. I don't know if this is
true or not and don't know where to go to verify her information. Before I
upgrade to 2002 or 2003 I want to be sure I need to upgrade.

 

[Michel Walsh]

Hi,


I am not personally aware of that problem, sorry.


Vanderghast, Access MVP