maximyshka
asked on
Help with VBA Code in Access 2010
Hi. I have following code below. Purpose is to open the form "Financial-Table form-PO". I would like to use as a filter (2 queries): "qryInputForm-CLOSED",
"qryInputForm-CLOSED-befor e conversion".
How can i modify below listed code?
I changed lines
stfilter="qryInputForm-CLO SED-before conversion"
DoCmd.OpenForm stDocName, stfilter, , stLinkCriteria
However, I got an error "type mismatch"
Please see the code below (before adjustments)
"qryInputForm-CLOSED-befor
How can i modify below listed code?
I changed lines
stfilter="qryInputForm-CLO
DoCmd.OpenForm stDocName, stfilter, , stLinkCriteria
However, I got an error "type mismatch"
Please see the code below (before adjustments)
Dim stDocName As String
Dim stLinkCriteria As String
Dim stfilter As String
Caption = "PAID LOANS MODE AFTER CONVERSION"
stDocName = "Financial-Table form-PO"
DoCmd.OpenForm stDocName, , , stLinkCriteria
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER