H
hootyeah
I have a main form named "Jobs" which contains the subform
"JobRoomDetails" - "Jobs" has a one-to-many relationship with
"JobRoomDetails". Both set to single form.
"JobRoomDetails" contains a combo called "Rooms" that assigns a
"RoomID" for every JobRoom record. Also on this form is a listbox
"JobRoomSelect" that I use to display all of the relevant JobRoom
records (all records that share the same JobID), with code in the
AfterUpdate property to find the matching record in the sub
"JobRoomDetails" This works fine except when I update the "Rooms" combo
it dosent update the listbox "JobRoomSelect" with the new "RoomID",
even when I have included the following in the "Rooms" combo
AfterUpdate property:
Forms!Jobs!Child89.Form!JobRoomSelect.Requery
The listbox will show the correct data when I re-open the form, and
even when it does display the old RoomID - selecting this will show the
updated record, but I would like the list box to display the updated
records the moment I assign a new RoomID.
What am I doing wrong?
Cheers in advance.
"JobRoomDetails" - "Jobs" has a one-to-many relationship with
"JobRoomDetails". Both set to single form.
"JobRoomDetails" contains a combo called "Rooms" that assigns a
"RoomID" for every JobRoom record. Also on this form is a listbox
"JobRoomSelect" that I use to display all of the relevant JobRoom
records (all records that share the same JobID), with code in the
AfterUpdate property to find the matching record in the sub
"JobRoomDetails" This works fine except when I update the "Rooms" combo
it dosent update the listbox "JobRoomSelect" with the new "RoomID",
even when I have included the following in the "Rooms" combo
AfterUpdate property:
Forms!Jobs!Child89.Form!JobRoomSelect.Requery
The listbox will show the correct data when I re-open the form, and
even when it does display the old RoomID - selecting this will show the
updated record, but I would like the list box to display the updated
records the moment I assign a new RoomID.
What am I doing wrong?
Cheers in advance.