I'm having a strange problem with a search field I have in a form. The code for it reads:
Private Sub cboProjectSearch_AfterUpdate()
Me.txtProjectName.SetFocus
DoCmd.FindRecord Me.cboProjectSearch, acEntire
End Sub
Private Sub cboProjectSearch_Click()
Me.cboProjectSearch = vbNullString
End Sub
It works fine except for Projects which have a pound sign in their name (example: "Dorm #1"). I have removed the pound sign in the name and tried the search and it worked. It is just a text field and from what I've read having a pound sign (or pretty much anything else for that matter) in a text field should not be a problem. Is there something wrong with the code that would make it not return a record from the search?