Drop-box help with links

[Shell123]

Hi there

I have a form with several things on it. There are 3 parts of the form that I am needing help on, although they are all connected.

I have a drop-box with 8 regions on it. Below this I have another drop-box where once an region is chosen all the appropriate addresses come up. Once you choose an address from that drop-box the customers full information comes up.

I can zip my database and send it to someone if they can help me??

By the way, I dont really understand the Visual Basic language therefore I sort of need basic instructions e.g go into properties and click......

Shelley

 

[PaulF]

You should have a query built for the second combobox that uses Forms!FormName.ComboBox1 as the criteria for the region field whose addresses appear in ComboBox2, and likewise the query for the data that is displayed should use Forms!FormName.ComboBox2 as the criteria row for the address field. In the AfterUpdate Event for ComboBox1 you need to send a Requery command to ComboBox2 (i.e. cboName.Requery), and in the AfterUpdate Event for ComboBox2 you need to send a Refresh command to the form to get the correct address to appear (i.e. Me.Refresh)

PaulF

 

[SteveR77]

Shelley,

Paul gave you what you needed, but this may help you as well.

How to Synchronize Two Combo Boxes on a Form

http://support.microsoft.com/suppor...xes&rnk=16&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000

Steve