Combo box error

S

SLow

I have an app that has run for years without problems. Recently I had an XP
Pro hang on startup an I was forced to reinstall Windows. I reinstalled
Access 97 SR-2 and now all combo boxes generate an error saying the object
cannot be found in VB and the ampersand is highlighted as the problem in the
following code:

Sub cmbWorkOrderLU_AfterUpdate()
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[Work Order#] = " & Me![cmbWorkOrderLU]
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub
This code was originally generated using the wizard and works fine on all
six other computers running this app.
Any ideas where I should start to look?

TIA
S.Low
 
L

Larry Linson

Tools | References to check for a missing reference. If one is marked
Missing, uncheck it, close and try again.
 
L

Larry Linson

You may have to repair the installation of Office or Access -- something
could have "not quite installed properly".

Larry Linson
Microsoft Access MVP
 
S

SLow

Larry Linson said:
Tools | References to check for a missing reference. If one is marked
Missing, uncheck it, close and try again.

SLow said:
I have an app that has run for years without problems. Recently I had an XP
Pro hang on startup an I was forced to reinstall Windows. I reinstalled
Access 97 SR-2 and now all combo boxes generate an error saying the object
cannot be found in VB and the ampersand is highlighted as the problem in
the
following code:

Sub cmbWorkOrderLU_AfterUpdate()
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[Work Order#] = " & Me![cmbWorkOrderLU]
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub
This code was originally generated using the wizard and works fine on all
six other computers running this app.
Any ideas where I should start to look?

TIA
S.Low


Larry
There is no 'references' option in my tools menu-another problem. Perhaps I
misspoke, this is still an .mdb file, not a real .mde app, so maybe that
option is not available in an .mdb file. I tried deleting and reinstalling
access, using the select all custom installation, w/o success. Any other
help will be appreciated.

TIA redux
S.Low
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top