Recent content by pepetheshrimp1

Many thanks for your help Arnelgp

Many thanks for your reply Arnelgp Sorry I should have mentioned that the Mechanism Field is a multiple entry field so I have found that instead of using just Mechanism I have had to use Mechanism.Value. I did just try your suggestion using Mechanism and Mechanism.Value but for some reason I...

Hi NauticalGent Many thanks for replying. Both combo boxes are unbound controls in the form frmGameSuggestions. In the primary table (tblGameStats) the Mechanism field stores multiple mechanisms (controlled by a lookup table) so there is multiple mechanism values for most records. Because...

Hi If someone could help me with the following query that would be great. I have created a form which I am using to filter a query. In the query I have created an expression shown below which works fine - giving me the value 1 if the combo box mechanismcbo is blank or has the relevant value...