G Gismo Registered User. Local time Today, 06:22 Joined Jun 12, 2017 Messages 1,298 Jul 3, 2020 #1 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?
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 AWF VIP Local time Today, 04:22 Joined May 23, 2011 Messages 4,807 Jul 3, 2020 #2 I would create a query and use that as the Row Source property of the combo box
June7 AWF VIP Local time Yesterday, 19:22 Joined Mar 9, 2014 Messages 6,018 Jul 3, 2020 #3 Provide example of data and desired output.
arnelgp ..forever waiting... waiting for jellybean! Local time Today, 11:22 Joined May 7, 2009 Messages 20,342 Jul 3, 2020 #4 you can even set the Rowsource Type as Value List and add the Values yourself.