Help with fields in form

[wizof103]

OK I want to use a table with 2 or three fields in a form that when I
select one value from the first field, the second field will auto fill
in. OK I have a table with two fields one called Facility and the other
called facility code. When I put in the the facility on a new record I
want the correct facility code to appear in the second field. The same
with another table with the Title, Title code and grade. I would like
to put the title and have the other two auto fill. I have talked to
people and they tell me to use a combo and text box. I just can set
these up to work. In the conbo box when you select it you see two or
three fields that you set up in the combo box wizard, but when you
release only the one field fills in. Thanks in advance

 

[David Lloyd]

The following KB article may be a useful reference.

http://support.microsoft.com/default.aspx?scid=kb;en-us;93138

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


OK I want to use a table with 2 or three fields in a form that when I
select one value from the first field, the second field will auto fill
in. OK I have a table with two fields one called Facility and the other
called facility code. When I put in the the facility on a new record I
want the correct facility code to appear in the second field. The same
with another table with the Title, Title code and grade. I would like
to put the title and have the other two auto fill. I have talked to
people and they tell me to use a combo and text box. I just can set
these up to work. In the conbo box when you select it you see two or
three fields that you set up in the combo box wizard, but when you
release only the one field fills in. Thanks in advance