How to add a record in a subform to another subform based on selection of record

[grampiano]

I have two mainforms which have two subforms

1) Mainform Inventory List with subform Supplierssubform
2) Mainform Supplier List with subform Supsubform

When I select Supsubform record it must automatically requery in Supplierssubform

My code works but it should display the record in the Supplierssubform instead it display the record in the Supsubform where i make my selection when I make my selection it should display in Supplierssubform not in the popup form where I make my selection. Any help, suggestions please

Heres my code

Private Sub SupplierName_Click()
Dim rst2 As Recordset
Dim rst1 As Recordset
 
Set rst2 = Forms![Supplier List]!Suppliersubform.Form.RecordsetClone
 
'find the current record
rst2.FindFirst "ID = " & Me.ID
 
Do While Not rst2.EOF
rst2.AddNew
rst2!SupplierName = Me.SupplierName
rst2.Update
Exit Do
Loop
 
rst2.Close
Set rst2 = Nothing
 
End Sub

[twinnyfo]

grampiano,

Welcome to Bytes!

I am not quite sure I understand what you are trying to do, either from your question or from your code. Based on your description, there is only one reference to a different Form, so it does not appear that your Form is trying to make the other subform "do" anything, other than using values for finding an ID.

Additionally, it looks like your code will add a new record if there is already a record that exists that meets the criteria.

Perhaps you can more clearly describe what it is you are trying to do. Please see this post for assistance: Asking Good Questions.

Hope this hepps.