lookup tables

[DaveB]

I have a form named Customer Orders Subform 2 that has a
lookup field from from Product:Table. Is it possible to
have Customer Orders Subform 2 fill in the new products
that I add to it into the Product:Table, where I can in
turn look them up and add them to Customer Orders Subform
2? How do I set this up.

I have the books Inside Out and Access 2002 Visual Basic
if you could tell me what pages to look it up on, if that
would be easier.

 

[John Vinson]

I have a form named Customer Orders Subform 2 that has a
lookup field from from Product:Table. Is it possible to
have Customer Orders Subform 2 fill in the new products
that I add to it into the Product:Table, where I can in
turn look them up and add them to Customer Orders Subform
2? How do I set this up.

If the Combo Box (the proper name of a "lookup field") is based on the
Product table, it should automatically pick up new entries to the
table - you don't need to do anything!

If you are entering data into the product table *while the form with
the combo is open* (perhaps in another form) you may need to requery
the combo to see the new additions. Hitting F9 will do it, or you can
use VBA code in the form where you're entering products:

Forms!OtherFormName!ComboBoxName.Requery

in the Form's AfterUpdate event, for example.