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
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