combobox stopped working

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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....
 
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....
 
Back
Top