Tab control question about updates

[Doug Sanders]

Searched but couldn't see this discussed.

I have a form with 5 tabs.

Data can be loaded three ways, manually entered, imported from a text file,
and imported from a Word template.

On one of the tabs (the second) when the user enters information such as a
social sec. number (SSN) that matches a file already in the system, a flag
goes off and alerts the user. Works fine.

On the import functions, the data is loaded and appears correctly, but when
the user moves to the second tab where the SSN number appears, it does not
set off the flag when the page opens.

I can make it happen with a couple of mouse clicks here and there but I
would like it to happen when the tabbed page is opened.

Using Access '97 at this time on this project.

Thanks,

Doug Sanders

 

[boblarson]

Make sure you aren't using the tab page, or tab control's CLICK event. It
won't work right. Make sure you are using the tab control's On Change event
to test which page has been selected and run the code accordingly.
--
Bob Larson
Access World Forums Super Moderator
____________________________________
Access 2000, 2003, 2007, SQL Server 2000, Crystal Reports 10/XI, VB6
WinXP, Vista

 

[Doug Sanders]

I'll give it a try.

Thanks,
Doug

Make sure you aren't using the tab page, or tab control's CLICK event. It
won't work right. Make sure you are using the tab control's On Change event
to test which page has been selected and run the code accordingly.
--
Bob Larson
Access World Forums Super Moderator
____________________________________
Access 2000, 2003, 2007, SQL Server 2000, Crystal Reports 10/XI, VB6
WinXP, Vista