First of all, I just want to point out that I don't know a particularly large amount about Access. Also, I would like to point out that this is probably a really dumb mistake on my part
OK, I've created a combo box with a custom value list. Basically, using code, I want a button to run a certain query depending on what has been selected in the combo box.
To test it, I have just been telling the button to display a message box (for example):
Private Sub Command10_Click()
If Me.cboSearch.Value = "Contractor ID" Then
This works fine. However, changing the value to any of the other options doesn't work! I'd like to point out that Contractor ID is the first option in the list.
Help would be appreciated ASAP please
EDIT : OK, some of them are now working. The spellings definitely weren't wrong, but by simply renaming some it is now working. Sorry for this pointless thread
I have another question though - I have created a search facility. However, it only brings up records that match exactly. Is it possible, for example, to search for names including "Dave" and have all records that contain Dave be included? Or even just a single letter and all names that contain the letter be included? I would still like to use queries as I am atm though, as it is vital to something else.