Combo Box Error - no displaying data

I

IT-1957

Hi every one, I have a combo box that looks up data in a form, I have 3
columns:
ID, WEEK ,ORDER
When I set up the combo to look for the firts column, ID it works fine but
when I try to look up the Order it doesn't show anything. It looks like is
there, I can actually scroll down to the "list" but I can not see or select
anything.
The code the the wizard creates is:

Private Sub Combo26_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

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

What actaully changes between them is the formating of the visible colums on
the property of the combo box itself....
Now The form works fine on another computer but it does not work on my.
I already check for Updates and there are not more available.
Do I need to reinstall Office or there is a solutions for this?

Thank you for your help.
 

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