We've recently upgraded some from Win2k w/ Office 2000 to WinXP w/ Office 2003 and this error popped up. I can't seem to figure out how to fix it. I'll try to explain the best I can.
There's a main form that is used to assign a room to people (B_RationActivityMainForm)
Within this form is a subform (SingleQuartersSubForm) that uses another form as it's source object (B_SingleQuartersAssignmen
SubForm has a view as it's Record Source which looks something like this:
SELECT RankGrade, SurName, SQ_TransAutoNum, TrgActivityAutoNum, SvcNum, CF_Rank, RoomAssignment, RoomStartDate, RoomResEndDate, RoomMethodOfPayment, RoomResCounter, RoomResNotes, BldgNum + ' ' + RoomNum AS RoomAssignText, RecCreateByUserName, RecCreatePC_Name FROM A_BuildingsTbl
Although only SvcNum, CF_Rank, SurName, RoomStartDate, RoomResEndDate, RoomAssignText and RoomResNotes are displayed on the form.
So the user will choose the SvcNum (which auto populates the rank and last name), the start and end dates. Then they press a little button to assign a room. This button opens a new form where the user can choose the room to assign. Once they choose the room they press the enter button which is supposed to update B_SingleQuartersAssignment
SubForm with the room assignment. Here are the lines that are run when the user presses enter:
t] = Me.ListOfAvailableRooms
What its supposed to do is assign the room id to RoomAssignment in the view (which is working fine) and then requery SingleQuartersSubForm so that RoomAssignText is displayed with the new info. This is the line that is causing the error.
Here is a screen shot that may help give a better picture.