I have a combo box that obtains its record set via SQL which has a criteria applied to allow filtering of records to take place.
The criteria is obtained from a form object and VBA assigns a value to the form object accordingly.
The criteria can range from a value of between 1 and 7, but it is also possible that a full set of data may be required, in which case no filtering is needed.
What would be the value that I need to assign to the form object that allows the query to return the full record set. I have tried "Like '*'", but this didn't work.
Many thanks for your help!!
The criteria is obtained from a form object and VBA assigns a value to the form object accordingly.
The criteria can range from a value of between 1 and 7, but it is also possible that a full set of data may be required, in which case no filtering is needed.
What would be the value that I need to assign to the form object that allows the query to return the full record set. I have tried "Like '*'", but this didn't work.
Many thanks for your help!!