Entering Parameter Value

[Hollis]

Hello everyone,

I have set up a report so that when it opens it asks for a Program ID. I have set up a form with a list of Programs and a button that when you press it will hopefuly open a report showing the information for the program you have selected in the list.

So heres my problem, I have no experiance with codeing and so I was hoping someone could help me with the coding part of it.

Just to make things clear this is what I would like the code to do (not nessarly in this order):
- Retreive the programID from the combo box
- Open up the report R_info
- Insert that programID into the Paramerter feild when the form asks for it
- Then have the form with the information for that programID

Sorry if I haven't used the right wording or if I'm not going about this the right way, I'm very new to all this.

Thanks.

 

[DCrake]

Desing your report and select the OnLoad Property

Next Type in the following code

Me.Filter = "[ProgramID] =" & Forms("NameOfYourForm")("NameOfYourComboBox")
Me.FilterOn = True

Save you report and call the report via your form using a valid program id in your combo box.

David

 

[Hollis]

I have it going now.

Thank's alot!