Selecting a customer on a form

[Goody974]

Hoping someone can help with this... I am such a NooB and have tried searching and experimenting, but clearly I am doing something wrong.

At the moment I have a form that gets filled in by the staff with customer name and address details. Each of the address and name boxes are individual fields (ie companyname, address1, town etc)

This form then prints out to a report with all those details on.

I would like to have a customer database and on the form just a drop down box. The operator selects the customer from the dropdown box and this populates the fields on the form which then prints. Effectively just saving the customer details having to be input over and over again.

Ive got as far as having the dropdown box which then puts into the main table the customer ID when its changed, but I cant seem to update the form or the report with the address details? I have created a relationship between the 2 queries of customerID in the main table and ID in the customer database.

What am I missing?

 

[arnelgp]

add the address,company, etc.. in your combo's rowsource.
example of combo's rowsource:

select customerID, customerName, companyname, address1, town

next add code to the combo's after update:

Private sub combo_AfterUpdate()
Me.txtcompanyname=me.combo.column(2)
me.txtAddress1=me.combo.column(3)
end sub

 

[Goody974]

add the address,company, etc.. in your combo's rowsource.
example of combo's rowsource:

select customerID, customerName, companyname, address1, town

next add code to the combo's after update:

Private sub combo_AfterUpdate()
Me.txtcompanyname=me.combo.column(2)
me.txtAddress1=me.combo.column(3)
end sub

Thats great thank you!

 

[Goody974]

Thanks Pat for the info.

In fact I think the first answer gives me exactly what I'm looking for as it's for creating a calibration certificate which of course shouldn't change.

The details stored with the cert will always be the same, but say if the customer moves address then of course we update the customer record byt the cert will always have the same details on it.

Hope that makes sense?