Unbound Form w/ a subform

[Bob Barnes]

I had this in "General Questions", but there were no replies...

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

 

[Bernie]

I had this in "General Questions", but there were no replies...

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

It could be because the the filter is set to a date and you are trying to
add a new record. Remove filter and see if it works.

 

[Bob Barnes]

Bernie - that wasn't it.

I have other Apps similar to this where this isn't a problem.
I'll examine all the Form Properties and see if I can find
something causing the problem.

Thank you - Bob

I had this in "General Questions", but there were no replies...

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

It could be because the the filter is set to a date and you are trying to
add a new record. Remove filter and see if it works.