New Record Form Load

[Spentak]

I have a main form that has a donorID. My subform is connected to my donor ID. When my form loads how to I get a certain field in the subform to create a new record on a table. For instance:

Table1
DonorInfo

DonorID(PK)

Table2
DateTime

DateTimeID(PK)
DonorID(FK)

I need the DateTimeId to create a new record for the selected donor in the main form. How do I do this?

 

[ErikSnoek]

You didn't specify on what event you'd like this new record to be created. If you do it on form load, as your post suggests, a new record would be created every single time the form gets opened..

 

[Spentak]

New Record

Yes, but how do I get that new record to contain the donorID number(which has already been selected on the main form) donorID is the (FK) on my datetime table(which gets a new datetime record just fine. My problem is I don't know how to get access to put the donorID number in the FK in the table that gets a new record.

 

[ErikSnoek]

I'm not completely sure if I get what you mean but have you linked the the DonorID field on the main form to the DonorID on the subform? This can be done in the Data tab of the properties of the subform. Note: The properties of the subform object, not the properties of the form IN the subform object.