Heya, I've got a listbox set to simple multi-select that I want to select rows on form-load based on values in a table (tblStaffBooking).
The table (tblStaffBooking) has BookingID and StaffID.
The listbox's rowsource is this statement:
SELECT [FirstName], [LastName], [ID] FROM tblStaff WHERE ([NotEmployed]=False) ORDER BY [LastName];
I want something like: if a row in (tblStaffBooking) has [BookingID] = " & Me.txtBookingID.Value & " then select the corresponding row on the listbox that has an identical StaffID (column 2 on listbox).
Reckon you could help me?? Need this for A-level coursework :/ There's this, then designing a weekly calendar in a report
Thanks!
The table (tblStaffBooking) has BookingID and StaffID.
The listbox's rowsource is this statement:
SELECT [FirstName], [LastName], [ID] FROM tblStaff WHERE ([NotEmployed]=False) ORDER BY [LastName];
I want something like: if a row in (tblStaffBooking) has [BookingID] = " & Me.txtBookingID.Value & " then select the corresponding row on the listbox that has an identical StaffID (column 2 on listbox).
Reckon you could help me?? Need this for A-level coursework :/ There's this, then designing a weekly calendar in a report

Thanks!