How to refresh tabs

S

spacerocket

I have two tabs, A and B. I want to make the db to refresh tab A when user
press on tab B, and when user press tab A, tab B is refreshed.

Both tabs contain some combo boxes for input, and user might input on the
wrong tab. So, when user press the Save button, then the input in the wrong
tab may also be saved if there is no refresh.

Please help.
 
J

John Vinson

I have two tabs, A and B. I want to make the db to refresh tab A when user
press on tab B, and when user press tab A, tab B is refreshed.

Both tabs contain some combo boxes for input, and user might input on the
wrong tab. So, when user press the Save button, then the input in the wrong
tab may also be saved if there is no refresh.

Please help.
Click to expand...

I'm confused. A Tab Control does not contain data. It's just a tool to
share screen space; any combo box or other control on a Tab Page is
actually bound to the entire Form's Recordsource; there are no
separate tables or record sources for different tab pages (though you
can, of course, put a Subform control on a tab page).

What is the Recordsource of your form? What are the Control Sources of
the controls in question? How can a user "input on the wrong tab"?
Surely you can set up the form and the controls so that the data goes
to the right table field!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
S

spacerocket

Well, my database is a payment transactions db, tab A is actually "Income"
and tab B "Expense"...

The user have to click on the correct tab to input the data.. If user is
recording income, then user must make sure the Income tab is active so that
data can be keyed in. Please advise.
 
J

John Vinson

Well, my database is a payment transactions db, tab A is actually "Income"
and tab B "Expense"...

The user have to click on the correct tab to input the data.. If user is
recording income, then user must make sure the Income tab is active so that
data can be keyed in. Please advise.
Click to expand...

Please advise me, so I can.

What is the Recordsource for this form? What are the Control Sources
of the textboxes on the form? Does each record have one and only one
Income field, and one and only one Expense field (that would be odd;
I'd expect one-to-many relationships to two related tables)? How can
you possibly expect Access to know that the number 328 typed into a
control really should be getting typed into a different control, if
it's otherwise a valid value?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top