Command Button - Please help.

[Guest]

I would appreciate any help with this. I have a command button on my main
form that when you click on it it will take you to the main switchboard and
the reports page. This is the what I have now. My Switchboard has two
pages. Page one has forms and button to go to the second page which lists
reports. This only takes me to the main switchboard. If I type
[SwitchboardID] is says there is no such field. I want the command button to
take me to the second page of the switchboard and open reports.

This is the info in the switchboard table for Reports.
SwitchboardID = 2; ItemNumber = 0, ItemText = Reports; Command = 0
How do I write this into the code? Thank you in advance for any help.


Private Sub cmdRPTS_Click()
DoCmd.OpenForm "Switchboard", [ID] = 2

End Sub

 

[Graham Mandeno]

This should work for you:

DoCmd.OpenForm "Switchboard", , , "[SwitchboardID] = 2"

[Note the two extra commas - they are space fillers for two optional
arguments that are not being supplied]

 

[Guest]

Yes - it worked! Thank you much.

This should work for you:

DoCmd.OpenForm "Switchboard", , , "[SwitchboardID] = 2"

[Note the two extra commas - they are space fillers for two optional
arguments that are not being supplied]
--
Good Luck

Graham Mandeno [Access MVP]
Auckland, New Zealand

I would appreciate any help with this. I have a command button on my main
form that when you click on it it will take you to the main switchboard
and
the reports page. This is the what I have now. My Switchboard has two
pages. Page one has forms and button to go to the second page which lists
reports. This only takes me to the main switchboard. If I type
[SwitchboardID] is says there is no such field. I want the command button
to
take me to the second page of the switchboard and open reports.

This is the info in the switchboard table for Reports.
SwitchboardID = 2; ItemNumber = 0, ItemText = Reports; Command = 0
How do I write this into the code? Thank you in advance for any help.


Private Sub cmdRPTS_Click()
DoCmd.OpenForm "Switchboard", [ID] = 2

End Sub