Forms and Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On my form I have 2 list boxes and 1 text box (Box 3). Once I select the
data for list box 1 and list box 2, I want list box 3 to run a query against
a table using the values on the form in box 1 and 2 (the where statement) to
get the data for box 3. Afterward I want to beable to have a command button
that will append the form data into a different table.

I tried a couple of things but I do not have the correct syntax etc.

Thanks
 
In the AfterUpdate of both of the 1st two controls, call a proc that
modifies the rowsource property for the 3rd control. This is done with VBA.
 
This is something I have not done before. Can you give an example of how the
data in list box 1 and 2 could be used to populate the data in box 3?
 
Back
Top