Form and sub-form

  • Thread starter Thread starter J. Shrimps Jr.
  • Start date Start date
J

J. Shrimps Jr.

Have a form with two sub forms. Each subform is based on
different queries, whcih in turn are based on different
tables, but the ID for each query is the same (the ID
selecting in the combo box of the master form).
When all the data is entered on the first sub form
(subform1), and the focus moves to the second sub form
(subform2) just below it, the data no longer appears on
the first sub form.
Selecting the same ID again on the master form
combo box (causing the master form to be requeried) makes
subform1 data appear.
How do I make the data entered on subform1 always appear,
even when it doesn't have the focus?
 
Maybe when the focus moves from subform1 the data is saved
to a record and the form empties ready to take the next
new record.
Consider not having the subform bound to the table/query
but 'insert into' later
 
Back
Top