B
Bill H.
(originally posted in wrong forum)
I have a form with several tabs. Three of those tabs (tab 1, 2, 3) are
subforms. Each of those subforms has the same data source (a query), and
the same relationship to the main form's data source. The query is an outer
join to another set of tables related via the query.
What's happening is that when I go to, say tab 1, and input some data and
then move to one of the other 2 tabs, I get an error about duplicate key,
etc. The fun part is that if, while I'm on tab 1, I move the record pointer
to the next record and then come back, I can added data on tabs 2 or 3
without getting that error.
I don't understand, but I'm thinking that somehow the data I input via the
first subform is not getting written to the other related tables until the
record pointer is moved. Just a guess, but seems to have some logic.
So, how to I fix this little problem?
Thx.
I have a form with several tabs. Three of those tabs (tab 1, 2, 3) are
subforms. Each of those subforms has the same data source (a query), and
the same relationship to the main form's data source. The query is an outer
join to another set of tables related via the query.
What's happening is that when I go to, say tab 1, and input some data and
then move to one of the other 2 tabs, I get an error about duplicate key,
etc. The fun part is that if, while I'm on tab 1, I move the record pointer
to the next record and then come back, I can added data on tabs 2 or 3
without getting that error.
I don't understand, but I'm thinking that somehow the data I input via the
first subform is not getting written to the other related tables until the
record pointer is moved. Just a guess, but seems to have some logic.
So, how to I fix this little problem?
Thx.