Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
can I use openargs value in a query...how
- Thread starter RBE
- Start date
JerryDennison
IS-IT--Management
OpenArgs is not a property of queries. What are you trying to do?
You would be opening your form something like
dim DocName as string, LinkCriteria as string
DocName = "MyForm"
LinkCriteria = "the criteria I want to pass"
'- for example a key to search on
DoCmd.OpenForm DocName, , , , , , LinkCriteria
In the Form being opened in the OnOpen event
dim mySQL as string
mySQL = "Select * from mytable where mycriteria = " _
& me.OpenArg
me.recordsource = mySQL
dim DocName as string, LinkCriteria as string
DocName = "MyForm"
LinkCriteria = "the criteria I want to pass"
'- for example a key to search on
DoCmd.OpenForm DocName, , , , , , LinkCriteria
In the Form being opened in the OnOpen event
dim mySQL as string
mySQL = "Select * from mytable where mycriteria = " _
& me.OpenArg
me.recordsource = mySQL
- Status
Similar threads
- Locked
- Question
- Locked
- Question