linking subform to form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a RefundRequest table (many) linked to a Provider table(one). I have a
form to update the RefundRequest table and a subform to update the Provider
table. The linking field is ProviderTaxID. I have updated the link
master/child fields for the subform. However, when I input a ProviderTaxID on
the subform, it does not automatically populate the same field in the
RefundRequest table.

This should be easy, but the answer eludes me.
 
Paulo,

It sounds like your master and subforms may be reversed. A
master or main form should hold the 'one' record of a
one-to-many relationship and the subform should hold the
'many' records.

Does one RefundRequest have many Providers or is it really
one Provider that has many possible RefundRequests? If it is
the latter, you are reversed with your forms.

When you enter a record on a master record and then enter a
child record on the subform the child record will inherit
the ID or linking field from the master record. It does not
work in reverse where you enter a child record and the
master record is created.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use field to update multiple fields 4
Where is code for form/subform link 3
Form/Subform Problem 1
Set Change Event on Control from Nested Subform 0
subform within subform On Main for Child master link question 2
Form/SubForm error while reference the object 1
odd subform which is on the one side of a one to many relationship 6
Main Form and two Subforms 2

Back
Top