Query to look up all instances of name requested at startup

[sephiroth2906]

Hello all,

I have a form that passes information entered to a table. The form has a combo box which has the name of every employee listed as active based upon a different query, so the names will always be the same. I can see that the names are being passed to the table correctly.

I want to pull up, using a query, every instance of an employee name, along with the related information (in this case late arrivals along with the reason, amount of time and date) I attempted to use a "Like" statement in criteria under name as follows:

Like [Last name, First name]

I had done something in the past (which of course, I cannot find) that utilized something similar, so I could pull up the first several letters of the last name and then get the information I am searching for, but in this case, although the input box comes up at start of query, I get absolutely nothing back, so I must have screwed something up.

Anyone have an idea what that may be?



Thanks!

[June7]

How is the employee name stored - all in one field or multiple fields for name parts? Is the employee name the primary/foreign key or is there a unique employee ID field that is the pk/fk. Use the ID for search.

[sephiroth2906]

It is one field, and it is not the key. There isn't any way for the users of the program to know the pk/fk associated with the employee, and each employee can be entered multiple times for multiple violations, so I cannot make them the key.

As I said, I know I have accomplished this once before, back when I was all studied up on access. Perhaps I need to start from scratch and try again.

I welcome any other ideas.

Thanks!

[June7]

Users don't need to know the pk/fk. They select the employee but code uses the pk/fk for search criteria. Use a multi-column combobox. The ID field is hidden, users select employee but the search refers to the ID column for criteria.

[sephiroth2906]

Ok. So, I just realized my query works exactly as written, and I am an idiot because I forgot to put the asterisk after the part of the last name I type. It is amazing what you can forget in a couple years.

Thanks so much for the help!