Use data from form for quary and display result on same form

B

Bosque

From some radio buttons on a form i generate a quary using:
Set qrynew = CurrentDb.CreateQueryDef("qryConditionSource", StrSQL)
This changes the data that textboxes in the form refrence. How do I get the
textboxes to update their contence with the new quary data from VBA?
 
S

Steve Schapel

Bosque,

I am not sure I understand the process you are using here.

Perhaps you could try this instead:
Me.RecordSource = strSQL
 

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

Top