Adding a new record based on selected record in subform

[simon123]

Hello all, long time lurker and first time poster. I am sure this has come up before but I am not sure how to work it in the search terms, so apologies in advance



I am a new user to Access and getting to grips with it, without delving into the scary waters of VBA and SQL.

I have created a subform on a tab control. I want to create a pop-up form, which is related to the subform, so I can enter and edit records



This form represents a two day course, where the DT are the delivery team who are running the programme on each day. The subform on the tab control shows the date and time of each session and when the click the button Add/Edit DT - the floating form pops up to display the DT on that particular day. So far so good, it works and only shows people who are running the programme on that day - thing is, I want to be able to add more DT members to that session and when I try to add someone, I get a pop-up saying it cannot find a record based on the matching fields, and I get it's because I am not adding any data to the ID field (I have hidden it on the pop-up form).

Is there a way of entering new records on the pop-up form, where it "assumes" the ID field based on the record in the subform where I clicked the button, so the user doesn't have to add it themselves.

Relationships as follows:


I hope this makes sense - please treat me like an idiot

Thanks

simon

[June7]

Requires code to pass value between independent forms. Use form/subform arrangement and code not needed.

[simon123]

Hi June7

Thanks for your reply.

I will have a google of subform arrangement to pass a value through to the second form. Thanks

[simon123]

Hi Again!

So I have added a macro to the button which creates a variable. I am then trying to pass this into any new record on the new form (using a macro on load event) but the field I want to populate remains blank. The variable is working as I have a text box displaying the number but the new record doesn't do anything. Is am wondering if this may be because I have created a 'multiple items' form.

Thanks in advance!

[June7]

Code would have to be in Current event. I don't use macros. Also never used TempVars. In VBA, something like:

If Me.NewRecord Then Me!BookingDateTimeID = TempVars!tmpBookingTimeID

As soon as record is initiated by entering data into another field, the Current event should trigger and populate ID.