Changing recordsource of a tabular form on AfterUpdate event of combo

[jamierbooth]

Hi All. Due to my employer giving me Access 2000 to build with, and everyone else Access 2000 Runtime to use the DB with, I'm having trouble building them a dynamic sort and filter option, because Runtime doesn't let you use the normal sort and filter.

It seems like my only option is- as the thread title says; to have them adjust a combo, which fires an event that changes the recordsource property then the results in the (tabular) form update to their selection. There's a combo to sort, and another to filter - I only need to filter results based on a single "Status" field, to show whether a client is open, closed etc. or set the sort order to 1 of 4 choices.

I've read lots and tried lots more and so far no success. I've created several different queries that can used to to base the recordsource on but still nowt. Perhaps I'm having "understanding issues", but I was hoping that a

me!recordsource = "qryopenfilter" 'or whatever type of filter they've selected
me.requery

type arrangment would do the trick, which I could then set into an If statement etc. but all the results just disappear.

Any help?
Cheers, Jamie.

 

[GinaWhipp]

Hmm, this should work but it depends on the query. What is the SQL of the query?

 

[jamierbooth]

Aha!! You mentioning that forced me to revisit the queries and I discovered some errors in the field names used. So it wasn't the code, it was the 'like' statement in the queries. (said cboType instead of txtType).

Thanks for pointing me in the right direction!

 

[GinaWhipp]

No problem, glad you figured it out!