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