Drop-down box and loading related data

R

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?
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Another Reason to Hate Insurance Companies (as if you needed one) 1
Contents of a drop down box based on the selection in another drop 1
Displaying Multiple Fields in a drop down menu 3
nonfunctioning cbo box 3
Restrict Choice in Shared WB (drop down alternative)? 0
Linking drop down boxes 3
Muliti-level Drop Down box 3
Using a drop-down box to sort data based on seperate columns 2

Top