List box

[srideout2525]

I have a form with a sub form.

On the main form I was hoping to have a list box, of the main forms 'suppliers' and when clicked all their info should show in the text boxes on the main form, and their first rate should show in the sub form.

I've tried a few things, but no luck yet....any help??

thx

 

[FoFa]

You basically have to go to the proper record on the main form, or filter the records to only display the proper one, there are many ways to do this. If you use the combobox wizard to setup a lookup box, it will generate the code for you that you can use. Your subform needs to link the proper fields between the Main form and itself is all it should take.