Access 97 - How to set up dependent form fields???

[Jim Iezzi]

My question is regarding a database form that I've
created. My form is used by technicians to enter test
data from production equipment being tested, i.e.,
product, part #, serial #, defects, etc.

One of these fields allows them to select one of our
products from a combo box list. The next field is a
serial # field that must be manually entered. Serial #
formats are different for each product and that is the
heart of my problem -- many tables to choose from and
setting up a combo box only allows the choice of one
table.

I want to automate the serial # field by using a combo
box that will display the correct serial # table based on
the product selection in the previous field.

Being a novice, I've tried to do this with a macro
without success. I'm thinking I could do this by writing
code in a module, but I don't know VB.

Any help will be greatly appreciated.

Thank you,
Jim Iezzi, Bombardier Transportation

 

[Joan Wild]

You shouldn't have 'many' tables to choose the serial # from. They should
all be in the same table.

As I understand you, you need a table of products with the product
information. You have many serial numbers for each product. So you need a
table for the serial numbers which would be related many to one on the
product table.

Also a combo box rowsource can be a table, query, or sql statement (so you
are not limited to one table).

You can set the second combo box's rowsource to refer to the first combo's
value. Details at
http://www.mvps.org/access/forms/frm0028.htm