Cross referencing combo boxes to a text box

R

Ray Woods

As part of a form that adds data to a table I have two combo boxes and a
text box bound to a reference table. The reference table contains lookup
data with four columns named Site, S1, S2, S3 and S4

I would like to be able to select the site with one combo box and then the
column headers S1,S2 or S3 with the second combobox. The text box would
display the value in the table referenced by the two combo boxes. All three
values (combo1,combo2 and textbox) would then be written to the table that
the records were being added to on the form.

Can anyone please help as I'm getting in a knot

Ray
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top