Link to home
Start Free TrialLog in
Avatar of maximyshka
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-before conversion".

How can i modify below listed code?

I changed lines

stfilter="qryInputForm-CLOSED-before conversion"
 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

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of lee555J5
lee555J5
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of maximyshka
maximyshka

ASKER

Thanks Lee