DLookup Name Error - Cascading Combo Boxes in Microsoft Access


	Back to Cascading Combo Boxes Comments List

Upload Images @Reply Bookmark Link Email

DLookup Name Error

Matthew McHenry

3 years ago

So, Try recreating the cheese from 5:12 from the member video. I have a form where I am going to need to do the trick 5 times. Frist one was done no problem. The second time not so smooth. This combo box is based on a Query because it a Many-to-Many that based on a joint table. Although the Combo boxes works and store the correct info in the correct Feild and table.

When doing the Cheese, I'm having a problem, with the Second DLookup box. Having a #Name Error being displayed. Picture to follow

	Matthew McHenry OP @Reply 3 years ago

	Matthew McHenry OP @Reply 3 years ago

	Matthew McHenry OP @Reply 3 years ago

	Matthew McHenry OP @Reply 3 years ago

	Kevin Robertson @Reply 3 years ago
You are missing quotes in your DLookup (Image 2) `=DLookup("NickName", "ManufactureT", "ManufactureID=" & ManufactureCombo)`

	Matthew McHenry OP @Reply 3 years ago
Awesome That fixed But it is giving me the wrong information. It giving me the first Manufacture in the Table. for all the records. My guess the ManufactureCombo on the form is being reset from the afterupdate code. Pictures to follow

	Matthew McHenry OP @Reply 3 years ago

	Matthew McHenry OP @Reply 3 years ago

Scott Axton @Reply

3 years ago

Matthew I think your understanding of how a continuous form works is not how they actually work.
If you change the manufacturer of any one record it will change it for all of the displayed records.

Yes, you are displaying multiple records but you are really working with one record. Its confusing, or at least it was to me at first.

Go watch the Hide Field Continuous Form video. Richard explains it better.
Also watch the Search 2.0 videos.
That will maybe provide better ideas on how to filter down your products.

	Alex Hedley @Reply 3 years ago
Continuous Form - Dependent Combo

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Cascading Combo Boxes.