When I open the combo box in the attached file and type, the system tries to find the ID number when I type. I would like to type a letter to find a last name. Any simple way to do this without anything complicated? Thanks in advance!!
When I open the combo box in the attached file and type, the system tries to find the ID number when I type. I would like to type a letter to find a last name. Any simple way to do this without anything complicated? Thanks in advance!!
Select the field you wish to search by clicking inside said field before launching the search.
I must not have explained it properly because clicking in the last name field before opening the combo box and typing a letter did not work. However, thanks for trying!
No, I think you explained it correctly. I had a hard time understanding and the graphic threw me off.
You can hide the ID and other fields of your combo by adjusting the Column Width Property. Adjust it to 0 if you do not wish to see it. Another approach would be to adjust the SQL of the combo's RowSource so the Last Name field is listed first, within the SELECT statement.
This combo box is unbound and is based on the entire form.
This combo box is unbound and is based on the entire form rather than on a single field.
Can you post the RowSource for your combo? After you do that, take a look at the properties of your combo. Look at the Column Width, Column Count, and Bound Column.
I will try it, ItsMe, and will report back soon.
Here is the photo of your requested information.
Yeah umm. I am not motivated to type out all of that SQL. You think you can copy it out of your DB and paste it here. If you double click the field, it will open a window so you can see it all.
I tried changing the SELECT statement as shown below but I got the following error. Please let me know if you can help me, and thank you for your continued help.
I modified the SELECT Statement as shown below but then I got this Mismatch dialog box and then an Action Failed dialog box, both as shown below. I look forward to your thoughts, and thanks again for your efforts.
Yes, I will post the code in my next reply. Thanks again. Sorry about that.
The idea is to copy the syntax here and I will edit it for you. Then you can adjust your properties so the form will function properly. It seems you have spaces between the names (like qry Clients). So I guess this is how it was originally.
SELECT [qry Clients].[ID Clients], [qry Clients].[tbl Clients].[First Name], [qry Clients].[Middle Name], [qry Clients].[tbl Clients].[Last Name] FROM [qry Clients];
let me know how rthat works and don't worry if it does not.
SELECT [qry Clients].[tbl Clients].[Last Name], [qry Clients].[tbl Clients].[First Name], [qry Clients].[Middle Name], [qry Clients].[ID Clients] FROM [qry Clients];