Drop down box (1 Viewer)

[Gismo]

Hi All,

is it possible for a drop down box to look up values from different tables then to display a summary of the 2 tables
or should this be done with a query and then linked to the drop down box source?

 

[bob fitz]

I would create a query and use that as the Row Source property of the combo box

 

[June7]

Provide example of data and desired output.

 

[arnelgp]

you can even set the Rowsource Type as Value List and add the Values yourself.