I have a Hotel Reservation system and the reservation form has two dropdown lists that are related. The first is a list of Hotels (cboHotels) rowsource 'fields' and the valid event stores the hotel ID (id_hotel) to a public variable (gnHotel). The second is a list of Room Grades (cboGrades) that hotel offers with the RowSource a View. Both of these are BOUND to the Reservation record.

The View (vRoomGrades) has 4 fields "grade_desc,hot_grade,grade,id_hotel" and I perform REQUERY() passing 'gnHotel' from the cboHotels.Valid(). For the most part this works fine, yet when I navigate through the Reservation records (next,back) I get 'Record out of Range' with one hotel, yet there are records for that hotel. Where is the best place to call the Refresh() or Requery() for cboGrades, and what could be causing this abnormal behavior?

Any ideas here would be helpful.
Adam