Forms

[dr223]

Hi,

I have two forms, main form is called stu_details and second form (look-up form) is called payr_lkup_name. On the second form I have a combo box which acts as look up for payer's names.

What I want is that when the a payer name is selected it is populated on the main form (stu_details) whauch has a subform called pay_det_sub and the field to be populated is called payer_name which is in the subform.

Thanks much appreciated

 

[Rich]

Why not put the combo box on the main form? and please delete the duplicate post

 

[dr223]

That would be easier yeah, but I dont have enough space on the main form. Thats why... What I want to do is when the payer code is selected, the payer code is populated on the subform.

Please find the attached database, hope you dont mind helping...

Secondly, I would like to create a relationship between the main form and the subform via the numhus value. A record with a specific numhus should only show the details of the payer on the subform!!

At present it gives the following error qur_pay.txtpayer_code, qur_pay.txtamount, pay_det_sub.student_id.....

Thanks