Using mainform w/subform

[Blondie96]

I need a form that will enter user information
username, type of room needed, reason. Once this information is entered, I want to create a reference # for the request & save that data to a table.
so main for would look like:
name
room type
reason
reference # (hidden & calculated)

(at this point I need the information saved to table1)

Then I believe I need to use a subform for the person to enter dates & times the room is needed. I believe to link the two forms I would use the refernce # created in the mainform.

Can someone tell me how I could force the first table info to be saved before going to the subform?

Thanks

 

[lupins46]

You don't have a choice. You won't be able to get to the subform without saving the main form and Access will save it automatically.

 

[Blondie96]

Hi Lupins46

Thank you, I'm rather new at this. I didn't know that's how access handled things. I'm glad that won't be a problem to deal with.