I have pre-assigned each record with a room number. There are 573 room, therefore there are 573 records. What I want to happen is that when a room is selected from the drop down menu on the form, I want it to display the correct matching record, but the record does not change and the form sits on record one. Does this make sense? For example, if I choose room 3, I want it to show record 3 on the form so the information can be entered. Is there any way I can do this?