!Problem in resorting a form or subform based on parameterized query

  • Thread starter Savvoulidis Iordanis
  • Start date
S

Savvoulidis Iordanis

Access 2000
I use a parameterized query to fill a form or subform with records from a
back end DB
in datasheet mode.
The form/subfrm initially does not have any recordsource set.
I manually set it in form's open after I fill the parms of the query and run
it.

qdf.parameters(0).value= xxx
set rst=qdf.openquery...
set me.recordset = rst

I do that in order not to get the ugly Access parameter window

All fine up to now.
When I use Access sort toolbar button, I now get the ugly Access parameter
window. Why?
The problem does not appear when I set the form's recordsouce directly.
But I want to have queries to get the records, not SQL strings that are set
to the recordsource of the form
How can I overcome this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

!Recordset from a parameterized query, as the form's recordset. Problem on sorting... 2
Populate main form from subform record 0
Using SQL Query Code in Form Module to Return Record Count 2
Parameter query 1
ADP form with parameterized function not prompting at runtime 2
problem populating continious form with vb6 8
Subform won't show data in Access 2007 4
unbound subform on unbound form: getting data into subform 1

Top