Please read post 14 and lets make sure the DB is working before we proceed. Put it back to how it was and test it. Then, we can switch things around.
Please read post 14 and lets make sure the DB is working before we proceed. Put it back to how it was and test it. Then, we can switch things around.
That didn't work to be able to type in Last name into the search box. That statement allows me to search by ID number.
OK, let me read post 14 and make sure it is working again. I will test it and let you know. You are very kind to help me.
Made a mistake....
OK, it works again. I put it back to the original.
OK, it looks like the SQL you posted will work to get the last name first. Here it is
SELECT [qry Clients].[tbl Clients].[Last Name], [qry Clients].[tbl Clients].[First Name], [qry Clients].[Middle Name], [qry Clients].[ID Clients] FROM [qry Clients];
Now when you place this in there, you will need to adjust the Bound Column. It was originally 1. With the new SQL. Id Clients is at the end. We will need to change the Bound Column value to 4.
Test that and if it works you can hide the ID column in column widths using the last value listed. There should be 4 measurements. Changing the last measurement to 0" will hide the ID column.
Awesome! I understand what you are saying. I will try it and will report back soon.
ItsMe, you did it! THANK YOU!!!!!
Glad to hear.