Lookup field in a table will not allow me to use auto expand
Lookup field in a table will not allow me to use auto expand
(OP)
Hi all,
Have a table called students which I want to use as the lookup to a table called [student Attendance].
In the table [student Attendance] I have a field called student which I use the lookup row source
SELECT Students.ID, [Students].[Last Name] & ' , ' & [Students].[First Name] AS LastFirstName
FROM Students
ORDER BY [Students].[Last Name] & ' , ' & [Students].[First Name];
If I did not concatenate the two fields last name and first name and use them separately then I can view the table and make changes by typing the students last name in the field and then quickly selecting the name. But if I concatenate then I have to use the mouse to select the value from the combo list and if I do enter any text it will not help to get the correct selection.
Does anyone know a better way of doing this so I can use the mouse as infrequently as possible?
Apologies for incorrect naming convention
Have a table called students which I want to use as the lookup to a table called [student Attendance].
In the table [student Attendance] I have a field called student which I use the lookup row source
SELECT Students.ID, [Students].[Last Name] & ' , ' & [Students].[First Name] AS LastFirstName
FROM Students
ORDER BY [Students].[Last Name] & ' , ' & [Students].[First Name];
If I did not concatenate the two fields last name and first name and use them separately then I can view the table and make changes by typing the students last name in the field and then quickly selecting the name. But if I concatenate then I have to use the mouse to select the value from the combo list and if I do enter any text it will not help to get the correct selection.
Does anyone know a better way of doing this so I can use the mouse as infrequently as possible?
Apologies for incorrect naming convention
RE: Lookup field in a table will not allow me to use auto expand
I strongly recommend that you do not use lookup fields directly in a table. This is OK to do in a query or on a form, but do not put it directly in a table. You can google numerous articles on the dangers with table lookup fields. http://access.mvps.org/access/lookupfields.htm. With that said,in a query if I set the row source to
CODE -->
Bound Column:1
Column Count:2
Column Widths:0";1"
The auto expand works fine without issue. Not sure why it is not working for you.
Intellisense deals with the completion of code.
https://code.visualstudio.com/docs/editor/intellis...
RE: Lookup field in a table will not allow me to use auto expand
As the table properties do not have the auto expand property, did some tests at the form level.
For my existing form which I removed all fields and then added the studentid field, changed to a combo box and then added the data source ect....
Still would not allow auto expand.
Created a new form from scratch, just adding the studentid, result WORKED
Moved this form over so that it was a subform on existing form (mimicking the problems forms position) WORKED
You beauty! Thanks very much for taking the time to help me out. Think we can close the case.