I have a form that I can fill, navigate update, and edit etc with no problem.

One of the columns in the dbtablethe form picks up from is "department" and I would like to be able to limit the data that gets returned into the datatable to the department chosen in the combobox. I can do this by adding the WHERE "department" =? and then setting the parameter to ? from the combobox.

My problem is if i want to fill the dataset with all data regardless of department how do i do that? I was hoping I could set the ? as % and that would select everything but of course it didn't.

Is there an easy answer or a better approach i should consider?

Many Thanks

Scott