Hi Richard, I have followed the search seminar and I cant get the combo box on customer form to work, does it have anything to do with the version of access (O365)
Many thanks
Adam Schwanz
@Reply 5 years ago
Combo box search works fine on o365. What error are you getting? Rewatch and check yours.
Combo boxes haven't changed much in years. Try a new blank database. Also check the Troubleshooter.
Julian OkolonjiOP
@Reply 5 years ago
Thanks Adam/Richard for the prompt reply, what I discovered was if I open Customer form via the CustomerList form it does not work but if I open Customer form directly it doesn't, and I would like Customer for to be open only via the CustomerList. Does its have to do with the fact I used 2 diferent queries, one for the CustomerF and one for the CustomerFilterCombo. Any tips?
Adam Schwanz
@Reply 5 years ago
What is the error you are getting though? Does it say anything?
I'm just assuming your problem is your customerlist has an openform where ID="&ID so when it opens the form, its filtered to be a 1 of 1 record. Nothing to search with.
Adam Schwanz
@Reply 5 years ago
You can get around it by instead of doing openform with a where clause, using recordsets, which you learn about in the more advanced courses.
DoCmd.OpenForm "FormName"
Forms!FormName.Form.Recordset.FindFirst "ID=" & ID
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Search Seminar.
