Open form based in a specific record

[Garcimat]

I want to open a form based in 3 conditions 2 conditions will come from global variables the third one is a value from the tbl_data
When I double click in the list SWO Number will send the value to the global variable gvar_SwoNumber and PTF Number will send the value to the global variable gvar_PTFNumber third one will be “Active” in the column Record_Status on my tbl_data…. Then open the frm_PTF2 with the record based on the criteria above, so I can edit or cancel the record.
Now I am using an access query…. Double click in the list >open the query> open the frm_PTF2 My database is getting to messy I would like to kill this access queries and open my forms using VBA.
I being trying for days, lots of reading and YT videos but still I can’t get it…. I even tried some sql but it don’t let me use my global variables as conditions…. Do you guys recommend some book or web site I really want to learn and help others and no only be sucking the knowledge from you guys.
Thanks

 

[June7]

Provide your code as text in post or provide your database - follow instructions at bottom of my post.

 

[Gasman]

Isn't this just the same as your other thread, just using different fields and criteria?
In your other thread, I thought you were missing a comma, thereby putting the criteria as the filter name and not the criteria?

Look at the syntax https://docs.microsoft.com/en-us/office/vba/api/access.docmd.openform