upsizing Query with Parameters

[Donna Brooks]

Hi,
I am trying to upsize queries with parameters, some very simple, ie. [All
CPUs with expiration date before] and the ones I am mostly concerned about
reference a combo box on the active form, using this for requerying. Here is
the SQL view of one the query referencing the active form, which work great
in Access :(
SELECT tblManufEquipType.ET, tblManufEquipType.Manuf
FROM tblManufEquipType
WHERE (((tblManufEquipType.ET)=[Form]![cmbEquipType]));

Any help would be greatly appreciated! I am a rookie with a deadline :)

Thanks Donna

[Jeff Boyce]

Donna

I believe the syntax you're looking for is something like:

Forms!YourFormName!YourControlName

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Donna Brooks" <Donna...@discussions.microsoft.com> wrote in message
news:EF6A7FA3-2454-40D1...@microsoft.com...