Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

No errors, freeze on change of 1st Tab

Status
Not open for further replies.

hondurab

Technical User
Jul 19, 2001
14
US
I'm having a problem after making changes (checking boxes) on the first tab of many on a form. The whole form freezes except that I am still able to check additional boxes on the first tabbed subform.

If I enter the tabbed forms, don't make entries on the first one but switch tabs, then go back to the first and make my entries, I am able to proceed normally.

I get no error messages (how can I make that happen?) and can't figure out where to start. This is another's database, which acquired this problem when it converted from 97 to 2000.

Thanks for any help.
 
Conversion from Access 97 to 2000 issue...you have to add Me.Requery everywhere that calls for a form refresh. This is the second such issue I've run across. The first time I had to add a second requery at the beginning of the function.

Adding a requery on form load solved my stuck tab problem:

Private Sub Form_Load()
DoCmd.GoToRecord , , acFirst
Me.Requery
End Sub

...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top