my COMBO Box only finds the 1st field

[lois chipperfie]

I'm totally frustrated. I know this is "easy" but have read and read & cannot find the answer. I want to be able to select a name from a combo box and then have the address, city state & zip code fill in automatically. All I ever get after selecting the name is the address & city-state-zip from the 1st record no matter which name I pick from the dropdown box. I'm new at this! Hope you can help!!

 

[sambo]

Use the Event Tab under the Properties menu to access the After Update Event of your combo box.
Click the drop down list and choose [Event Procedure]...
Now Click the little ... Box next to [Event Procedure]
This will take you into the VB Code Window.
Inside the current Module
(should be cboSomething_After_Update)

Type the following:

Me.Requery


THAT'S It!!

THat will tell the form to get the new data according to what the combo box has been loaded with.

Good Luck..

 

[Ally]

This happened to me last week - the first combo was requerying the second one correctly, but whatever record I chose from the second combo, only the first record would appear.

I overcame it be re-investigating my relationships. These were a bit wrong and by re-sorting them out, sorted out the problem. If this is what was happening to you, I thought this may help.

 

[lois chipperfie]

I do not have the table linked to another table. I'm trying to create an invoice by having the name & address auto fill from an address table and then use another table to fill in the item & price. I just cannot get the dlookup to work.

 

[sambo]

I recently had a problem w/ Dlookup also.

Make sure to include the ' ' characters around strings.

Dlookup("[fieldSearched]", "tblOrQueryName", "[field] '" = Me.myControl & "'"

Its hard to see, but you need the little single quotes for STRINGS ONLY (that means fields of type, text). Numeric searches do not require the tick (') mark.

Good luck