Okay, I have two forms Navigation Form, and a continuous form that shows up as the Navigation Form's subform.
The continuous form is laid out to show me all records based on a search. For each record that's displayed, an command button displays beside it. So, when using the Navigation form, the command button is located within the subform. The command button (btnEditRecord)'s OnClick event is configured as such using a macro:
OpenForm
Form Name: frmEditRecord
View: Form
Filter Name: (blank)
Where Condition = =" [ID]=" & [txtID]
Data Mode: (blank)
Window Mode: Normal
When the btnEditRecord is clicked, frmEditRecord opens as an entirely new window, displaying frmEditRecord and pre-loading all the correct information.
The problem is, I don't want it to open as a new window. What I want to happen is that when btnEditRecord is clicked, frmEditRecord opens in the Navigation Form's subform.
I've tried editing the Where Condition clause with various permutations of [Form]![Navigation Form]![NavigationSubform].[Form]![frmEditRecord]=" [ID]=" [txtID] thinking that might work. Unfortunately, along with breaking data entry, frmEditRecord ALWAYS opens in a new window.
What am I doing wrong, and more importantly, how can I get it right?