Query criteria based on Form Value

gheyman

Well-known Member
Joined
Nov 14, 2005
Messages
1,694
I have a query that I want to have a dynamic criteria based on what someone selects in a Combo Box on a form (the Combo is in the Header Section)

Like [Forms]![frm_Add_Supplier]![ComboVendorASL]

But when I try to run the Query, I get a pop-up that asks me to "Enter Parameter Value". Not sure why this is not working. I have done this before with no problem.

Any suggestions?
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

gheyman

Well-known Member
Joined
Nov 14, 2005
Messages
1,694
Re: Access: Query criterea based on Form Value

After closing and saving the database - this now works. Thanks
 

Watch MrExcel Video

Forum statistics

Threads
1,090,491
Messages
5,414,853
Members
403,549
Latest member
CascadeDiver

This Week's Hot Topics

Top