Recent content by theziff

Thanks for the reply. So if I build the SQL statement in VBA, what syntax/format should I be using to refer to the combo box in a form - in my database it's called [Forms]![TerritorySpecificRightsChooser]![Combo24] Sorry to be asking such a basic question - I've been checking around online...

Just a follow up - I'm looking to use the combobox selection as the "Field" in the query, rather than the criteria - I haven't been able to find anything online in regards to doing this, which is why I have the suspicion it might be problematic. Thanks again.

Hello, I've inherited a database that has a table with a large number of Yes/No fields. Apart from normalizing the database, I was wondering if the following was possible: ContractTable has Yes/No Fields for rights granted for each order (television, dvd, internet etc). Using a form, the...