Form and Subform relationship

[ZJGMoparman]

I have created a flight log database to keep up with my R/C flights. I have one form to enter a flight session and then a flight form to enter new flights. The flights table has a field for SessionID which is related to the SessionID in the Session table. I have a button in the session form to add a new flight. The problem is, when I add the flight, it does not assign the same sessionID that is open to the flight. How can i make it default to the current sessionID of the corresponding form i have open. I am attaching a link to download the database, if that will help things out. I am still new to access. Maybe someone could also give me some pointers on what I have so far and let me know what i have done wrong. I am trying to learn, so any help is appreciated.



http://d01.megashares.com/dl/S8sOK3A/Flight%20Log.accdb

[June7]

Do you want more than one aircraft associated with a session?

Instead of opening another form and trying to pass the SessionID to it, why don't you just enter the flight info in the subform? Master/Child links of the subform container control will synchronize the related records and the SessionID will automatically save to the flight record. Just click into any field of the New record row of the Flight subform to start new record, the command button not needed. Use the setup you have for FlightF form as the subform.

Are you the only user of this database? If you set it up properly and learn to use the intrinsic navigation tools, can be built without any code at all.