Search results

Thanks will try this method and abandon the idea of a split form - it is also proving hard to open as a popup and keeping a reasonable size. Seems split forms aren't the thing!! Thanks for all your help

This is my database set up. I have a table Assets which holds the data on all the assets as well as the user associated with that asset. The user names are taken from a table Users using a lookup to select the first name and consequently the last name. On the Asset form this is done by using a...

This is what I have but when the search filter [UserFirstName] Like "*"&[Forms]![AssetsQuery]![searchTxt]&"*" is used and I put in Sara it comes up with no recoreds but if I enter the ID number it brings the record up. My lookup is taking data from a table Users which has a FirstName and...

Not sure what you mean do it properly - if you mean not use the name then what do you suggest? It would be nice if you were a little bit more clearer in your message. I thought you were here to help!

My reply was to June7 but I haven't tried your solution yet I'm not to sure of VBA yet but I will try it. Thanks for the update

"Why would WHERE clause compare combobox with textbox? That makes no sense." Not sure why you have put this in not helpful really - as I said I was asking if it is possible to get the value of the second column in a combobox to use as a search value. "Why filter on first name? What if there are...

Yes I am using a lookup up for the name of the user associated with the asset. The users are in their own table form which I get the names.

Hi I have created a split form from a query which has a combobox which has 3 colomns ID, UserFirstName and LastName. The form displays UserFirstName in a combobox and LastName in a bound textbox. My problem is that I have created a Search button and textbox where the user can enter the...