Query criteria based on Form Value

gheyman

Well-known Member
Joined
Nov 14, 2005
Messages
1,690
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

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

gheyman

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

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

Forum statistics

Threads
1,089,678
Messages
5,409,695
Members
403,276
Latest member
Oscar007

This Week's Hot Topics

Top