Pass parameter from FORM to QUERY

  • Thread starter Thread starter jltbdy
  • Start date Start date
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
 
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 :)
 
Back
Top