Subform

[dr223]

Hi,


I have a table called payer_det which will record the details of the payers. This is a subform. I have other fields on the table which are not shown on the form. However, when a field such as payer_code is selected in the subform I want the other three fields i.e., fin_code, HESA, and fee_remitted to be populated on the respective table. There is a look-up table called Payer_lkup.

I want to do this without creating a field on the subform display...


Any help

Thanks