Transfer ID from Form to Query Subform field

[smcfadden777]

I have seen alot of posts that are similar but not the same as my problem. Seems like it should not be difficult.

I would like to send the ID from a form to a subform query after I have added a record to that subform query.

I have 2 table "Clients". which has an ID for each client and a table "Payments" which records the payments made by the client. I have a main form to display the clients name and ID.

I have a query that I have put into a subform that displays the clients payments on the main form.

How can I have the ID field in the subform automatically populated with the Client ID on the form when I add a payment to this subform?

Thank you.

[June7]

Have you set Master/Child links of the subform container control? This linking will synchronize the related records. As soon as any entry made in subform record the ID will populate in the subform record.

[smcfadden777]

I deleted that attempt but need to still do it, I will let you know.

Thank you

[smcfadden777]

I remade the subform and did as instructed and it worked fine. Turns out I had originally draged and dropped the subfrm onto the main form and did not have the benifit of an automatic connection.

Still have a problem though, The main form has gotten too crowded. I need to make the subform, "Payments", a seperate form that can be brought up by clicking a button on the main form, and allow auto population of the ID field in a new record on the new form, with the ID of the main form. Same problem on a seperate form. Thank you.

[June7]

Too crowded? Consider using tab control. Otherwise, need code.
Options:

1. Pass the ID value in the OpenArgs argument of DoCmd.OpenForm:
DoCmd.OpenForm "secondformname", , , acFormAdd, , Me.textboxname
Then Current event of form two:
If IsNull(Me!ID) Then Me!ID = Me.OpenArgs

2. first form code sets value of textbox on second form.
Forms!secondformname.textboxname = Me.textboxname

3. Second form refers to textbox on first form (first form must remain open):
IIf(IsNull(Me!ID) Then Me!ID = Forms!firstformname textboxname