Updating Buttons on Forms!!!

[Kckronic21]

Hi,

I have this problem. I have created several buttons on a form that go to several different reports. I am having to constantly change the name of the report so that they match my query names. I wanted to know if there was a way to update the code of my buttons to have the new report names after I manually change the report names.

Thanks

 

[Databaseguy]

Quit renaming them (LOL)


Refer to the reports ordinal position in lieu of the name.

Ex:

Private Sub Command11_Click()
Dim dbs
Dim rptName
Set dbs = CurrentDb
rptName = dbs.Containers!Reports(0).Name
DoCmd.OpenReport (rptName)

End Sub Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy