I am having trouble with a data access page using a group filter. I just want filter a set of records by a drop down. The drop down list is the listing of each record in the table based on one field.

I have a Table or query that I want to use a group filter. I have a good example from an access book but whenever I try it I get the error "Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another" Then "Can't filter records. The field name specified in the GroupFilterField property must contain values that have the same or a compatiable data type as the values in the group filter control".
I have looked at this every way I know how. I have an exact example from some code in an access book and even a sample dbase that works like I want this to work. I just can't seem to get past this error.
jpateusaAsked:
Who is Participating?
 
ee_ai_constructConnect With a Mentor Commented:
PAQ / Refund
ee ai construct, community support moderator
0
 
Jeffrey CoachmanMIS LiasonCommented:
jpateusa,

Are your samples based on Data Access Pages or Forms?
0
 
jpateusaAuthor Commented:
It is based on data access pages. Here is a little more information to go on. I have a query which pulls information from three seperate tables. Two of the tables are related to one another and the third is not (lookup values based on data in one table to the other). I can elevate the main id from one table and make it into group header that has a plus sign on it. That will work fine, but if I elevate the same field to another header and make it a group filter control it won't work and gives me the error above. I could email you exact tables, forms, data access pages, etc if it would help. It  works like it is but isn't what I want. I want to display a record from a table using a drop down box to do the filter. There is some code in the book I have to do a find command on a data access page using VB Script but I have not tried that yet. I do appreciate your help and I hope you have a great week.

Jason Pate
0
 
Jeffrey CoachmanMIS LiasonCommented:
jpateusa,

Thanks, but the only reson I asked was in case you meant "Form"

All I know is that usually the Web team hadles things like this, not the DBA.

The web team can usually do this easilly in Frontpage, ASP or Dreamweaver.
0
 
jjafferrCommented:
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I will leave the following recommendation for this question in the Cleanup topic area:
    PAQ with points refunded

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

jjafferr
EE Cleanup Volunteer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.