MS Access: Search data from a Text Box
Posted on 2007-07-27
I'm currently designing a MS access DB (2003) and have a table/query which has a list of user names and Cubicle numbers. I'd like to copy a picture of the floor plan in a blank form and then place a box over the cubicles and have a lookup expression in there that will search the table/query for the name associated to the cubicle in question.
In MS excel I would use the Vlookup function to search a sheet and find the cubicle name and then show the box 1 to the right which would be the name, how would I do this in access?