tabs in a form

[Dimitris Nikolakakis]

I have a form FOrders and a TABctrl with two subforms in two tab pages.

The two subforms take data from same table (orderstx)

In the first subform I input some records. When I click on the second tab
page I do not see the new records that I have created. I must close and
reopen the form.

I have tried the requery or refresh data but no result

Thanks in advance
Dimitris

 

[Rick Brandt]

I have a form FOrders and a TABctrl with two subforms in two tab
pages.

The two subforms take data from same table (orderstx)

In the first subform I input some records. When I click on the second
tab page I do not see the new records that I have created. I must
close and reopen the form.

I have tried the requery or refresh data but no result

Normally having two forms both opened and bound to the same table will lead
to editing conflicts. Also it is completely normal that when you first open
a form it will only have access to the records that existed at the time it
was opened. If additional records are added after the form is opened it
must be requeried for those records to appear in the form. To that end you
could issue a Requery command in the Change event of the TabControl.

I'm curious though why you even have two subforms if they are both bound to
the same table.