combobox stopped working

N

NetworkTrade

had a combobox set up via wizard (Access2003) that worked fine in selecting
the record to be shown in the form.

came back recently and found it not to be working...

The only code in the AfterUpdate event is what the wizard supplied:
Private Sub Combo26_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[OrderID] = " & Str(Nz(Me![Combo26], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub


The only thing I can recall doing between then and now - was making
NotVisible many of the controls on the page - because the form would open to
data that confused the reader - before they selected a record....

Is making the controls not visible affecting the combobox?...or otherwise
what does one do to repair this combobox to select the record?

tia
 
N

NetworkTrade

incomplete info before....I threw on a new combobox and it also doesn't work...

this is in a subform - - I so I guess that is a key issue.

the parent form has a combobox that works fine....pulls up customer

this subform combobox is pulling (suppose to be) the records of this
customer....
 
N

NetworkTrade

relooked at previous front end version - and it works fine....

and the hidden controls are already there so that isn't a factor....

am baffled as to why this combobox is now not working....
 

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

Similar Threads

Combo Box Value 1
Combobox 1
Pkey Search not working 4
Combo box to find a record in Access 2007 1
Find the record that matches the control. 3
How to update control 3
Combo Box results to Subform 1
Combo error 1

Top