RE: Combo box - only allowing it to show specific data from anot

Hi Clare

Thanks for the question.

For both parts the query behind the combo box needs changing. To get the unique values you need to change the query properties. Either right click in the query design window and get the query property dialog window up, then change "Unique Values" to Yes.

OR If you are happy to change the SQL you need to add the word DISTINCT after the word SELECT in your statement.

To do the second point is slightly harder. Is there a date of entering recorded in your database? Access does not do automatic auditing.

If there is then you need to add a criteria to that datefield.

If you are wanting to change the combobox source data from within vba then the line you are looking for is something similar to:

Me.cmbNames.RowSource = "Select Distinct [Product Names] from [tbl Products] where [CreateDate] >= #" & me.InputDate & "#"

I hope that helps

Laura