Form Creation

  • Thread starter Thread starter RC-
  • Start date Start date
R

RC-

Hi all,
I am extremely new to Access and I would like to create a form that will
allow a user to click on a dropdown (combo box) select a location and then
the other three fields will be automatically populated. The other three
fields consist of Phone, Fax, and Address respectively. I already have a
table with the correct data in it. I just don't know how to populate the
other fields automatically.

Any help would be great!
TIA
RC
 
If your form has the RecordSource property set to your table, and your
controls are all bound to their respective fields, and you want the form's
recordset to move to a specific record after a selection is made from the
combo box, then here is a link for information about that:

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



Hi all,
I am extremely new to Access and I would like to create a form that
will
allow a user to click on a dropdown (combo box) select a location and
then
the other three fields will be automatically populated. The other three
fields consist of Phone, Fax, and Address respectively. I already have
a
table with the correct data in it. I just don't know how to populate
the
other fields automatically.

Any help would be great!
TIA
RC
 
Back
Top