Re: Populate a field in a subform

[dr223]

Re: Populate a field in a subform

Hallo,

I have a subform called FeesDetails. This subform is made up of a table called FeeDetail which is built up of 5 fields , Payer_code, Fee_Amount, Session, Payer_name and Payer_address.

Payer_code is also a list box containing all the payer_codes.

Now, what I want to do is that when I select a certain Payer_code such as for example AHS, I want the Payer_name and Payer_address to be populated automatically, with Ashfield High School (Payer_name) and 20 Tooting Road, London (Payer_address).

How can I do that, please?

Thxs

 

[Uncle Gizmo]

How to do a self look up.

.
Assuming your subform is displayed in form view and not datasheet view, and assuming the listbox you mention is actually a combo box then I suggest you have a look at this set of videos here which demonstrate how to perform a "self look up". if your list box is a list box, then I believe that the code could be adapted to work with a list box. However I don't have much experience with list boxes, I usually use Combo boxes.

Cheers Tony