Allocating rooms

[quasimodo]

attached is a picture of one of my forms for a hotel booking/billing system....

the user selects the customer from the drop down list on the left, and the vacant room in which the customer will stay from the list on the right. How can i take these 2 selections and add them to the Bill table/form when the user clicks the 'allocate room' button...? Does it require an append query? and how do u make it so that when the Bill form pops open, that it opens on the new record that will just have been added when this room is allocated?

Also, i used subforms for each, and i was looking for a way to get rid of the grey spaces (circled in the picture) Can anyone help me out with this aswell...?

Thanks in advance

 

[Pat Hartman]

1. You can use an append query or use the addnew method (DAO or ADO) to add the record.
2. When you open a form using the OpenForm method, you can use the "where" argument to specify a particular record.
3. Get rid of the gray on the left by setting the RecordSelectors property to No
4. Get rid of the gray on the right by setting the ScrollBars property to Neither.
5. Get rid of the gray on the bottom by setting the NavigationButtons property to No
WARNING doing both 4 and 5 will prevent you from being able to scroll unless you add your own navigation buttons.