Access 2003 - Multi Select function on List Box...

[numms]

I'm having what seems like a pretty basic issue in Access, but I'm not sure what I haven't looked into yet...

I am attempting to create a lookup form which will allow the user to select multiple records, then perform a query based on the selections.

The List Box is being populated with the results of a query of all the record numbers in a table.

Another query has been created specifying [Forms]![AdjustmentFormSeach]![Combo0] as the only criteria of the lookup.

The problem seems to come in when specifying the Multi Select value in the properties of Combo0.

When the value for that is set to "None" everything works just fine, but the user can only select one record at a time.

When the value is set to "Simple", no records are returned at all, but the query does open.

When the value is set to "Extended", no records are returned.

I've tried changing the criteria on the query to be In([Forms]![AdjustmentFormSeach]![Combo0]) but that returns nothing either.

I've even tried adding a text box to display the values that are returned by Combo0 and I get a Null value even though there's no Nulls values in the list box.

Sorry if this is pretty basic, I'm still learning various ways to set things up in Access.

Thanks for any help that can be provided on this issue.