Fill In Multiple Fields in a form from a combo box?

  • Thread starter Thread starter James
  • Start date Start date
J

James

Hi,
Running Access 2000.

I have a form, AppPackage, that has 5 places in it that requires the
customers full name, 8 places that require the customers street
address and zip code and 2 places that require SSN.

I have a small form, AppInputForm, for inputting just this info and
would like to use a combo box that would allow the user to select the
FileNumber (common with both forms and have an established
relationship) from the combo box on the AppPackage Form to auto fill
in these multiple fields. I can see how this works with:

Example:

Me.address = address1

for one field, but how do I use the same data to post to several
fields at once?

Thanks for any help.

James
 
Hi,
Running Access 2000.

I have a form, AppPackage, that has 5 places in it that requires the
customers full name, 8 places that require the customers street
address and zip code and 2 places that require SSN.
Click to expand...

Is this an Access Form? or a paper "form" - a Report in Access terms?
Either way, you do NOT need to have five address fields in a table to
display that address five times on a Form (or on a Report). Just store
the address in your table *once*; AppInputForm should store the data
into this single Address field. On the Report (if it's for printing),
simply have five textboxes, all with [Address] as their control
sources; it will display the address five times.
 
Back
Top