I get an error message when I have written following as a criterion in a query: [forms]![FMenu]![cboUnit].column(0) I get following error message: The form FMenu with cboUnit is active and has a value. In Immidiate Window I type: ?[forms]![FMenu]![cboUnit].column(0) and get the value 2.
Remove the ".Column(0)" - it will default to the first column.
OK. Thanks! Worked.
Forum Rules