Combobox Lookup not working

W

Walter Levine

I have a form which is bound to a query on a single
table ordered by last name. There is a combobox in the
header for looking up client records alphabetically.
The combobox was generated by the standard wizard when
you drop it on the form. It works fine on my development
machine, but when I take it onsite, which is network
enviornment, the combobox does not work, it does not move
the forms' recordset to the selected record. It appears
that the After_Update event of the combobox is not
firing. It does not hit my breakpoint. I have verified
that the name is correct. When the combo box is closed,
nothing happens on the form. The exact same code works
perfectly on my development machine.
The after update code is as follows
*****************
Dim rst As DAO.Recordset
Set rst = Me.RecordsetClone
rst.FindFirst "[CompanyName] = " & _
HandleQuotes(cboCompany, cQuote)

If rst.NoMatch Then
MsgBox "No record matching " & cboCompany
Else
Me.Bookmark = rst.Bookmark
End If
rst.Close
Set rst = Nothing
***************************
Thanks for any help
Walter Levine
 

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