Form Design Help

[Bryan Brassell]

I am new to forms, please help me! I need a form whereby
the user can see particular fields and enter them if empty
or correct them if wrong, for indivdual records (pieces of
equipment).

I need to force their choices for these fields to be from
among the 'One' in another table (the records are in
the 'Many' table. How do I make this connection?

Thanks,

Bryan Brassell

 

[Bryan Brassell]

Thanks...now I have a combo box for the first field the
use needs to update. The second field, however, must have
its choice of items in the combobox determined by what was
chosen in the first field. Can this be done outside of
VBA?

 

[GVaught]

Would a main form/subform be the answer to your problem. The Main form (one)
has a subform (the many) which is related to the main form through the
primary key/foreign key relationship.