VoiceOfThePeople
Technical User
Hello Everyone,
First, I want to thank the posters on this forum for all of their assistance, insight and unselfish public servitude. I am attempting to build a database that will help me manage the lives, goals and progress of adults with developmental disabilities. I am fairly new at this but I have made some progress.
Issues: I have an employee list box that allows me to populate or update a form according to the employee selected when the record source is set to the original table. However, I recently altered the record source to a multiple table query and the Employee list box became inoperable. I believe the query that is now established as the new record source must reference the list box within the query’s criteria. However, I don’t know the proper expression to write within the criteria field to allow the employee list box to function as it had prior to changing the record source.
The fields in the list box are as follows:
AID=Assistant ID
ALName=Assistant Last Name
AFName=Assistant First Name
The list box name is lst_Employees
and the table is SLAdmin
Thank you in advance for any assistance you may provide.
First, I want to thank the posters on this forum for all of their assistance, insight and unselfish public servitude. I am attempting to build a database that will help me manage the lives, goals and progress of adults with developmental disabilities. I am fairly new at this but I have made some progress.
Issues: I have an employee list box that allows me to populate or update a form according to the employee selected when the record source is set to the original table. However, I recently altered the record source to a multiple table query and the Employee list box became inoperable. I believe the query that is now established as the new record source must reference the list box within the query’s criteria. However, I don’t know the proper expression to write within the criteria field to allow the employee list box to function as it had prior to changing the record source.
The fields in the list box are as follows:
AID=Assistant ID
ALName=Assistant Last Name
AFName=Assistant First Name
The list box name is lst_Employees
and the table is SLAdmin
Thank you in advance for any assistance you may provide.
