I have a form that I use all the time to keep track of things that I need to do. Each thing that I need to ‎do is called a job. Each job is associated with a client and a file under that client. Each client may have ‎more than one job, but the form only shows one job at a time.‎
There is another form that shows a client and all of the jobs for that client.‎
I wanted to put a button on the first form to open the second form and move by default to the client ‎that I currently had open.‎
I used dbcmd.openform  SecondForm ‎
I then used dbcmd.findrecord [clientname] in order to go to the first instance of that record. This order ‎for this form was set to [clientname]. I wanted to go to the first instance of the client s name and be ‎able to scroll through to see all of the jobs for that client and its related files.‎
I inserted a msgbox and debugged the code and the client name was correct. But nothing happened. ‎The form opened on record 1 and stayed there. I tried adding quotes and using less than the entire ‎client name and nothing worked. I even tried using the same technique with a macro. Each time the ‎result was the same. This one has me baffled.‎
Here is the exact code:‎
Private Sub OpenFormClientButton_Click()‎
‎    DoCmd.OpenForm "ClientWithTasksF"‎
‎    DoCmd.FindRecord Forms!TodoListwithworkF![ClientName]    ‎
End Sub

---

Reply from Richard Rost:

Why not just make JOBS a subform under CLIENTS?