Make a Combobox show Value list of a table.field without having form bound to table

[baulrich]

I have an unbound form used as a search/filter interface. For this reason, the form isn't bound to a table/recordsource. It has some search/filter fields that allow users to narrow down the results they want, which are displayed in a listbox in this form.



Some of the filter options are combobox's. I'd like the combobox to be populated with the same "Value List" that is allowed for a certain field in a certain table.

Table job has a field named category that has a row source type of "Value List" and a defined Row Source of "Type 1";"Type 2". What's the easiest way to get the combobox on my form (which again, is not linked to the job table) to display that same set of values (i.e. Type 1, Type2)? I'd rather not hard-code the same list to the combobox, but have it done automatically. But if that's not possible, I'd still like to know how to create the list manually.

thanks....

[June7]

Not really clear to me what you are asking for.

Copy/paste a control to replicate the properties.

Create the list manually by typing in the combobox RowSource property and set RowSourceType to ValueList