relating combobox and text boxes PleaseHelp!!

[Lisa O'Keefe]

I am a beginner and really need help. If anyone could give me some sample code on how I get information from 2 tables(I made a query) into the appropriate text boxes when I make a selection from my combobox (one thing that was causing me problems was that the combobox contained an autonumber which can't be bound). Please help me I have a deadline to get this form functional for tommorrow!




Liza

[James Longstreet]

you need to trap the Change event for the combo box and then refresh your data; and display it in the controls.

in your forms code, click the general combo and select your combo box from the list.
then in the declarations combo select the change event.

In the function it adds to your program, you can refresh you data in your textboxes.



Jim Hewitt
Software Developer
Liberty Tax Service
www.LibertyTax.com