multiple update and tab restrictions

I hop someone can help with this problem.

I have a database, based on a tennis booking system, when I update a time for a booking on a court, within a form, I need to update a seperate field, in a seperate table, with the same time. I have no idea how to do this as i can only get one to update at a time.

Also, I have 4 tabs on a form, when i enter information into one of them, i need to lock the rest of them out.

can anyone help with these problems.

The way I would do it is to have a command button on your form titled "Book" or something like that. Have the command button save the form, close the from then run an update or append (whichever is appropriate, hard to sy on what you've told us) query to change the data in the other table.