Open form based in a specific record (1 Viewer)

Garcimat

Member
Local time
Tomorrow, 06:08
Joined
Jun 7, 2022
Messages
67
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
 

Attachments

  • A5B03EFD-DA61-4703-919C-31B2C8E7A2EB.jpeg
    A5B03EFD-DA61-4703-919C-31B2C8E7A2EB.jpeg
    2.8 MB · Views: 56
  • 102D5258-8D18-4927-8C19-4BE1E9EE5C21.jpeg
    102D5258-8D18-4927-8C19-4BE1E9EE5C21.jpeg
    1.3 MB · Views: 50

June7

AWF VIP
Local time
Today, 12:08
Joined
Mar 9, 2014
Messages
4,462
Provide your code as text in post or provide your database - follow instructions at bottom of my post.
 

Users who are viewing this thread

Top Bottom