Pass parameter from FORM to QUERY

J

jltbdy

I have an append query that I trying to call from a cmd btn...but it
prompts me for the parameter(ie QuoteID)...
How do I tye it into my call:

Dim stQueName As String
stQueName = "Quote Query"
DoCmd.OpenQuery stQueName, acNormal, acEdit
 
J

jltbdy

I have an append query that I trying to call from a cmd btn...but it
prompts me for the parameter(ie QuoteID)...
How do I tye it into my call:

Dim stQueName As String
stQueName = "Quote Query"
DoCmd.OpenQuery stQueName, acNormal, acEdit
Click to expand...

In the query criteria for that field enter the reference to the form|
field:
=Forms!frmForm!RecordID

Works for me :)
 
Top