all field in combobox

I"m using a combobox to sort a query.

In the main form [Frm_RecallList] is a combobox call TxGrp.

There is a subform based on a query that has the where field states:
[Forms].[Frm_RecallList].[TxGrp]

When the user changes the combobox in the Frm_RecallList the Onchange event
is set to Requery the subform.

I can't get it to show all records. I tried not limiting to the list in the
combobox and allow * but it returns no records.

Any ideas?

Hi Ian

This should be a simple fix.

Access is interpreting the selection criteria for your * as [YourField]="*",
ie it must be an asterisk. What you need is the criteria for the query field
to be;
Like([Forms].[Frm_RecallList].[TxGrp])

This way it should always take an exact match when the user has made a
selection on the combobox, but when they select the asterisk it will use this
as a wildcard.

Try it out and see if it works.

Regards

Richard

Ian wrote:
I"m using a combobox to sort a query.

In the main form [Frm_RecallList] is a combobox call TxGrp.

There is a subform based on a query that has the where field states:
[Forms].[Frm_RecallList].[TxGrp]

When the user changes the combobox in the Frm_RecallList the Onchange event
is set to Requery the subform.

I can't get it to show all records. I tried not limiting to the list in the
combobox and allow * but it returns no records.

Any ideas?

--
Regards,

Richard
www.kardanconsulting.co.uk

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200903/1