I'm sure this is a very easy issue, but I can't work out what I'm doing wrong.
I am using unbound combo boxes to create filtered queries (using form!form name!combo box). The filtered queries are then used for different reports and forms. However, the combo box is emptying when I click a command button, and the query is returning a null value.
If I choose an option in my combo box, and manually run the query - the filter is working. It's just the 'auto-emptying' causing me problems. I can't find a setting/coding to suggest I've turned it on, so I assume it's a default.
Can I keep the value in a unbound combo box until I choose another one?
I am using unbound combo boxes to create filtered queries (using form!form name!combo box). The filtered queries are then used for different reports and forms. However, the combo box is emptying when I click a command button, and the query is returning a null value.
If I choose an option in my combo box, and manually run the query - the filter is working. It's just the 'auto-emptying' causing me problems. I can't find a setting/coding to suggest I've turned it on, so I assume it's a default.
Can I keep the value in a unbound combo box until I choose another one?
