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!

Cursor will not advance past a combo box

Status
Not open for further replies.

samyers

Technical User
Mar 15, 2007
15
US
I have a form which synchronizes two combo boxes: the contents of box 2 depend on the selection made in box 1. This has been working perfectly, and I haven't modified anything in the form for several weeks.

Today I opened the form to check something, and now the cursor will not move past box 1. I can change the value in that combo box repeatedly, but nothing else on the form is active except the Close button. After I hit Close, first I get an error saying that Access may have encountered an error while trying to save the record. If I then click 'Yes - close object anyway' I get 2 occurrences of an error saying 'The expression On Exit you entered as the event property setting produced the following error: Statement invalid outside Type block'.

I know that no one else has been in messing with this, and I know I haven't changed anything. I do know that our IT department installed some MS security patches last week, right before I started having problems. Is there any chance there's a problem with incompatible versions? I know I saw info about this error indicating that you might need at updated Microsoft Jet engine.

TIA,
Sheila
 
How are ya samyers . . .

Does the debugger show which [blue]On Exit[/blue] event is in error?

If yes post the code in the event.

If no, open the form in design view, goto the code module and post any [blue]On Exit[/blue] events you find . . .

Calvin.gif
See Ya! . . . . . .
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top