Access - easy one

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to create a form to add info to more that one table.

ContactInfo form (name, address etc) has a contactType field and associated
relationship to contactType table.
 
I would like to create a form to add info to more that one table.

ContactInfo form (name, address etc) has a contactType field and associated
relationship to contactType table.
Click to expand...

The simplest way to do this is to base the Form on a Query joining the
two tables. Be sure to have the ContactType field from *BOTH* tables
included in the query.

It may be safer to use a Combo Box control to enter the ContactType
and use the combo's Not In List event to add a new type when it's
needed (I'd guess that after the first week it usually won't be, but
then I don't know how you use the field...). Search at
http://www.mvps.org/access for "Not In List" for some sample code.

John W. Vinson[MVP]
 
Back
Top