SET RECORDSOURCE AT RUN TIME

[rry2k]

Hi,
I'm opening a report from a radio button using a DoCmd.OpenReport "presentation", acViewPreview.
I need to provide an option for different queries based on the users choice. Is there a way to change the recordsource property in code? My report is obviously named presentation.

Thanks..Russ

 

[datawise]

All you need to do is put the following line in the load event of the form to be opened

me.recordsource = "qryQueryName"

You can always call a dialogue to allow the user to choose the query before you set the record source.

 

[rry2k]

Hi,
The form that I open has 3 radio buttons(for test)
view by workOrderNumber
view by Candidate
view by Sales REP
after the choice is made, a parm query should run asking for a particular sales rep or...
then the report will be generated.
Thanks..Russ

 

[JoaoTL]

Hi, try like this.

docmd.OpenReport("YourReport&quot,acViewPreview,"YourQuery" Best Regards

---
JoaoTL
NOSPAM_mail@jtl.co.pt

http://www.jtl.co.pt

http://www.jtl.co.pt/Access

 

[rry2k]

Hi Joao,
I tried that and it went straight into the report and didn't stop for the parameter query. The report was empty.
Russ

 

[JoaoTL]

Hi, above is the Full syntax. Are you shure that your querie is OK?

DoCmd.OpenReport ("YourReport&quot, acViewPreview, "Query", "Where Conditions" Best Regards

---
JoaoTL
NOSPAM_mail@jtl.co.pt

http://www.jtl.co.pt

http://www.jtl.co.pt/Access

 

[rry2k]

Hi,
The query works fine outside of the report. The where clause is built in to the query not in the code. It looks like this:

SELECT Presentation.*
FROM Presentation
WHERE (((Presentation.Submittal)Like"*"&[Type a candidate:]&"*&quot);