Populating master table with info from list table

[sburgess]

I have a form that I am working on.

When you open the form, it asks for a tool # (which will be a drop-down box). There will be a command button that will bring up a sub-form. In the subform, there are 2 combo boxes. One picks the group that the tool falls under, and the other has the section of the group for the tool.

When the user picks the section, I need it to filter the questions that pertain to that section (which is listed in a list table), and pull those questions, and populate the master table with them. (i.e., Pulls "where is tool?" from tblQuestions, and puts it in the tblQuestionMaster when section is selected from combobox).

 

[zappa007]

Hey Len,

We're close....I mean really close...

I made the changes but now I receive this error...

The Number of Columns in the two selected tables or queries of a union query do not match.

here's the code...

SELECT DISTINCT union_qry_update.group FROM union_qry_update UNION Select null, "<All>" as Bogus FROM [union_qry_update]
ORDER BY [union_qry_update].group;