assign value to textbox from different tables

[joe55555]

Dear all,

I have a combobox which has 2 values: "kids" and "adults".
When the user selects item "kids", a textbox should display record from table named kids.
And when the user selects item "adults", the textbox should display record from table named adults.



any ideas please !?

Thank you

[Bob Fitz]

Not sure I understand your requirement. First. Once the combo selection has been made does it matter which record from the appropriate table. Second. A text box will only show one field from the chosen record. Is that what you really want?
Perhaps you could give us a little more info, in plain English, on what your db is about and what you are trying to do.