Brother Arnold
Member
- Local time
- Today, 05:24
- Joined
- Apr 28, 2022
- Messages
- 39
Hi,
I've got an appointment history continuous form populated with a query that lists all the appointments for a client and shows the counsellor name for each appointment. The counsellor name is found on the counsellor table via counsellor_ID that's stored on the appointment table. Sometimes admin want to change the counsellor name so I've made the counsellor name on the form a combo box and the dropdown lists all the names. However if I go to change the name it won't let me select a name. I suspect it's because I've got two tables in the query. If I simplify the query to one table and change the counsellor name to counsellor ID the combo works fine. Any ideas how I get around this?
The SQL for the query is:
For the combo I use a simple select in the Row Source and the Control Source is counsellor_name from the query
I've got an appointment history continuous form populated with a query that lists all the appointments for a client and shows the counsellor name for each appointment. The counsellor name is found on the counsellor table via counsellor_ID that's stored on the appointment table. Sometimes admin want to change the counsellor name so I've made the counsellor name on the form a combo box and the dropdown lists all the names. However if I go to change the name it won't let me select a name. I suspect it's because I've got two tables in the query. If I simplify the query to one table and change the counsellor name to counsellor ID the combo works fine. Any ideas how I get around this?
The SQL for the query is:
SQL:
SELECT tblAppointment.*, tblCounsellor.counsellor_name
FROM tblAppointment, tblCounsellor
WHERE tblAppointment.client_ID = 21 AND tblAppointment.counsellor_ID = tblCounsellor.counsellor_ID_pk
ORDER BY tblAppointment.appointment_date DESC;
For the combo I use a simple select in the Row Source and the Control Source is counsellor_name from the query