I got a solution for a combo box search button the other day but this is not quite giving me the result I would like.
If I open my clients form, I would like to have a search button that will open a pop up form allowing me to search the whole recordset (clients) but only by one field (for example "status"). I would like the pop up form to show the results in a list type format, and when I click on the result in the list that I am searching for, that this record be displayed in the main form which would still be open in the background.
The problem I am having at the moment with a basic search is firstly that I can only see one result at a time, and also that if I search for all records showing "hot" then I get all of the clents with hotmail e-mail addresses as well.
I hope this makes sense! The only problem is that I am a bit of a novice with this whole access lark and although I persevere until I get it right, in this case I don't know where to start!
Can anyone point me on the right path?