B
Bob Barnes
This has worked many times before, but now...
The App's Main Form (only one Form and one Subform in the
entire App) has 3 Tabs...unbound Controls on Tabs 1 and 3,
and a Subform on Tab 2. The Subform's RecordSource is a
Query where the criterion is.....
[Forms]![frmMain]![TheDate].
When opening an existing Record (a Date on Tab 1, when entered,
fills all unbound Controls for an existing Record, or lets the User
know it's a New Record.)
Opening an existing Record, and clicking Tab 2 places the Cursor
in the first Record of the Subform...which displays the "pencil", but
the User can't move to another Record in the Subform (have to use
The Task manager to End Task (the App). I have several
"Cancel = True" in the Subform, but can't find a condition to arrive at
Cancel = True.
Ideas? TIA - Bob
The App's Main Form (only one Form and one Subform in the
entire App) has 3 Tabs...unbound Controls on Tabs 1 and 3,
and a Subform on Tab 2. The Subform's RecordSource is a
Query where the criterion is.....
[Forms]![frmMain]![TheDate].
When opening an existing Record (a Date on Tab 1, when entered,
fills all unbound Controls for an existing Record, or lets the User
know it's a New Record.)
Opening an existing Record, and clicking Tab 2 places the Cursor
in the first Record of the Subform...which displays the "pencil", but
the User can't move to another Record in the Subform (have to use
The Task manager to End Task (the App). I have several
"Cancel = True" in the Subform, but can't find a condition to arrive at
Cancel = True.
Ideas? TIA - Bob