Embarrassingly simple

[mfpoore]

I only do this for about 30 seconds a year, but I know this one is easy, I just keep botching it. All I want to do is have a form that automatically finishes an address after you choose the facility name. Have a separate table for the facility name and addresses, just cant see, to get it to automatically fill in.
thanks,
mfpoore

 

[dopedealer]

Something i have just made in a few minutes, is this what you want? You can add more address lines if you wish to the table,query and the form itself. You said you wanted the address to be autofilled not for it to be saved so i have used Dlookup to achieve this, if you need further help let me know, an alternative solution is also available. It is possible to filter as per your needs in the query.
Best Regards,
Chris
________
Yamaha XT600

 

[mfpoore]

works well

That seems to work exactly as I need. Do I just add fields to the table and query to finish it off? (street address, city, state, zip...the usual)

thanks very much!
mfpoore

 

[dopedealer]

Yes,
Add the fields in the table and to the query, then add more textboxes to the form to display these field values and in the control scource modify the =Dlookup for each of the fields, if you want you can send the database or tell me the fields and i will set them up for you.
Best Regards,
Chris
________
vaporizers

 

[mfpoore]

it works

Thanks Chris, I went ahead and put them in, and it seems to be working fine.

thanks for the help

 

[dopedealer]

Glad to be of help
Best Regards,
Chris
________
Ducati Multistrada 1100 S