Drop-down box and loading related data

[RitchieJHicks]

I have created a form in design view.

I wish to have a drop-down box linked to the "Insurer" field on my database.
When the user clicks the drop down box I wish for them to see a list of all
the insurers (seperate records), so that they can then select that any
insurer and all the other data relating to that specific insurer should be
loaded into the fields.

Can anyone advise please?

 

[Golfinray]

Add a combo box to the form. Allow the wizard to do that for you and select
Insurer as the item to look up. Then right click on the box, go to events,
find the afterupdate event, click the little button out to the right, and
start the code builder. Type:
Me.filter = "[insurer} = """ & Me.combo# & """"
Me.filteron = true
The combo# will be listed, like combo10 or combo22