Let's say your sheet naming is in the form: "Room101" and hat your form hasa field called intRoomNumber. You can select the sheet you need in VBA usingsomething like:strSheetName = "Room" & str(intRoomNumber)Sheets(strSheetName).Select