Form subform data transfer

[WAVP375]

A form, FrmFinance, is bound with a query who gets its data from two tables, TblTenant whose prime id is TenantId and TblUnit whose prime id is UnitId. This information is displayed on the form for information only. The sub form, FrmPayment, is a data entry form bound with the TblPayment whose prim id is auto numbered. The TblPayment table requires the TenantId and UnitId which are both on the FrmFinance. What I am attempting to do is put the two ids on the payment form for further identification. I have searched the web and found several suggestions but every thing I have tried has failed with a message that says that I cant put anything in that field. You have never failed me, tell me how simple it is.

Thanks in advance

[kd2017]

Use the "Link Master Fields" and "Link Child Fields" of the subform control. You can use multiple fields to define the master/child relationship, just use a comma to separate each field.

[CarlettoFed]

Try attaching a sample file, with a minimum of non-sensitive data, to pretty much see what you've accomplished.

[WAVP375]

Thanks kd2017 that gets the job done. I knew you wouldnt let me down.

Thanks