Recent content by BobPaul01

Thanks to all. By reviewing your responses, I was able to get the job done. Cheers!

My form [Menu] has a combo box where ClientID is remembered for later use. I then open a form: frmClientEdit WHERE Condition= [ClientID]=[Forms]![Menu]![ClientID] Works ok. Except if the user fails to choose a ClientID from the combo box before opening the form, then a Microsoft Visual Basic...

Thanks to all. Pat - you led me down the correct path. It turned out I was making this more complicated than need be. The solution is to create a copy of the subform and use the WHERE clause to open ONLY the subform to the specific record desired. Then because the the two tables are related...

Thank you Paul. This does work in general. But in my case "Otherfield" is a field on the subform. It defaults to opening the first subform record.

Thank you. Your first examples is opening a continuous subform. I want to open a specific subform in edit mode. If I can't use Where clause or Filter, how can I open a specific subform in edit mode?

GOAL: Select an employee and project from a continuous form and open the associated employee form and project subform. I have a table (Employees) with a primary field EmpID. And I have a related table Projects that includes the EmpID. It also has the primary field ProjID) I have a parent form...

I have done basic access work before and am now learning how to do more with vba. Help needed!