Control editing on a tabbed form

I have a form based on 3 main tables with 3 tabbed pages-
Page 1 - Master record
Page 2 - Individuals related to Master record
Page 3 - Donations from Individuals

I am using event procs to control mis-editing fields when
using Find. On Current opens the form with Allow Edits
and Allow Deletions No. An EDIT button switches these to
Yes and turns the screen pinkish rather than blue. After
Update switches everything back to No and the screen back
to blue. This works fine when moving between records,
but does not work if the user hits the EDIT button then,
without changing anything in the record, hits the tab for
another page i.e. we are still in edit mode for the table
on Page 1.

How can I control the edit mode if a user switches
pages? I tried the On Click property on the tab control
but it didn't do the trick...

Thanks,
Sandra

Pehaps using the OnChange event of the tab control will work for you. You
could use that event to reset the EDIT settings.


--
Ken Snell
MS ACCESS MVP

"Sandra" wrote in message
...
I have a form based on 3 main tables with 3 tabbed pages-
Page 1 - Master record
Page 2 - Individuals related to Master record
Page 3 - Donations from Individuals

I am using event procs to control mis-editing fields when
using Find. On Current opens the form with Allow Edits
and Allow Deletions No. An EDIT button switches these to
Yes and turns the screen pinkish rather than blue. After
Update switches everything back to No and the screen back
to blue. This works fine when moving between records,
but does not work if the user hits the EDIT button then,
without changing anything in the record, hits the tab for
another page i.e. we are still in edit mode for the table
on Page 1.

How can I control the edit mode if a user switches
pages? I tried the On Click property on the tab control
but it didn't do the trick...

Thanks,
Sandra

Hi, Ken-
I could not find an OnChange event for the tab control.
The only "action" event seems to be On Click and I can't
seem to find the right method to change the EDIT settings
using On Click...any other ideas?

Thanks,
Sandra
-----Original Message-----
Pehaps using the OnChange event of the tab control will
work for you. You
could use that event to reset the EDIT settings.


--
Ken Snell
MS ACCESS MVP

"Sandra" wrote in message
...
I have a form based on 3 main tables with 3 tabbed
pages-
Page 1 - Master record
Page 2 - Individuals related to Master record
Page 3 - Donations from Individuals

I am using event procs to control mis-editing fields
when
using Find. On Current opens the form with Allow Edits
and Allow Deletions No. An EDIT button switches these
to
Yes and turns the screen pinkish rather than blue.
After
Update switches everything back to No and the screen
back
to blue. This works fine when moving between records,
but does not work if the user hits the EDIT button
then,
without changing anything in the record, hits the tab
for
another page i.e. we are still in edit mode for the
table
on Page 1.

How can I control the edit mode if a user switches
pages? I tried the On Click property on the tab
control
but it didn't do the trick...

Thanks,
Sandra



.

You likely are clicking on the tab page (likely the tab at the top of the
page) when you're looking for the events. Click on the outside of the entire
tab control (along its edge) -- you then should see the other events for the
tab control itself.

--
- - - - - - - - - - - - - - - - -
Ken Snell
MS ACCESS MVP

"Sandra" wrote in message
...
Hi, Ken-
I could not find an OnChange event for the tab control.
The only "action" event seems to be On Click and I can't
seem to find the right method to change the EDIT settings
using On Click...any other ideas?

Thanks,
Sandra
-----Original Message-----
Pehaps using the OnChange event of the tab control will
work for you. You
could use that event to reset the EDIT settings.


--
Ken Snell
MS ACCESS MVP

"Sandra" wrote in message
...
I have a form based on 3 main tables with 3 tabbed
pages-
Page 1 - Master record
Page 2 - Individuals related to Master record
Page 3 - Donations from Individuals

I am using event procs to control mis-editing fields
when
using Find. On Current opens the form with Allow Edits
and Allow Deletions No. An EDIT button switches these
to
Yes and turns the screen pinkish rather than blue.
After
Update switches everything back to No and the screen
back
to blue. This works fine when moving between records,
but does not work if the user hits the EDIT button
then,
without changing anything in the record, hits the tab
for
another page i.e. we are still in edit mode for the
table
on Page 1.

How can I control the edit mode if a user switches
pages? I tried the On Click property on the tab
control
but it didn't do the trick...

Thanks,
Sandra



.