docmd.openform where id= [id old form] i would like to see the rest records to navigate
Hello,
i have [form1] and [form2]
i want to open form2 with all records visible, and go to form2.id related to form1.id
(its like docmd.openform "form2",,, "id=" & idform1) but i would like to see the rest records of form2
Or
the same if i set docmd.showallrecords but i want stay on id i filtered.
I dont know if my question is clear..
i have [form1] and [form2]
i want to open form2 with all records visible, and go to form2.id related to form1.id
(its like docmd.openform "form2",,, "id=" & idform1) but i would like to see the rest records of form2
Or
the same if i set docmd.showallrecords but i want stay on id i filtered.
I dont know if my question is clear..
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
an example project would help the experts to give you a solution more eaily.
In general, forms are bound to queries, so one possibility is just to manipulate the query, which is behind the form.
DoCmd is a very old method from Access to deal with the environment and is a bit limited. So better to support it with a little bit vba code.
If you load a form, the designed query is behind the form and the form starts at the first record of the query as long a you do not advice something else. If you want to show a different record, you either have toi advice the form (as you have done it with DoCmd or you have to loop through the recordset and find the correcd record.