Help in fixing error message

[forest8]

Hi

I have created a form which contains information from three tables.

In this new form, I need to be able to include fields with multiple
responses. I have changed the fields to allow for multiple values and ability
to edit values.

Whenever I try to use one of these fields, I get the following message:

The multi-valued field cannot be used in an ORDER BY clause.

How do I fix this problem?

Thank you in advance.

 

[bhicks11 via AccessMonster.com]

How are you accessing the three tables on the form? Query with relationships?
Are you talking about combo boxes with multiple values? If so what is the
record source?

Bonnie
http://www.dataplus-svc.com

 

[PieterLinden via AccessMonster.com]

Hi

I have created a form which contains information from three tables.

In this new form, I need to be able to include fields with multiple
responses. I have changed the fields to allow for multiple values and ability
to edit values.

Whenever I try to use one of these fields, I get the following message:

The multi-valued field cannot be used in an ORDER BY clause.

How do I fix this problem?

Thank you in advance.

I hope you're using subforms, if not, it's going to get ugly. Multi-valued
fields are a MESS - whether it's Access, FileMaker or whatever. Another
great misfeature.