On-Click event transfer

[nkenney]

Hello,
I am hoping you can help me. I am using Microsoft access 2007. I have created a command button which when I click it, I would like to go to another form. I have created a On-Click Event with the following code:
Private Sub menu3_Click()
On Error GoTo Err_menu3_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Item Code"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_menu3_Click:
Exit Sub
Err_menu3_Click:
MsgBox Err.Description
Resume Exit_menu3_Click
End Sub
I have added MsgText commands After the Dim statements and nothing occurs. Any ideas as to what I am doing wrong?


Thank you in advance!
Nancy

[RuralGuy]

Hi Nancy,
When you go to the menu3 control in design mode and right click and go to the Event tab, what does it say next to the Click event?

[nkenney]

When I go to the Event tab, on the on-click it says [Event Procedure] and when I click on the button, it takes me to the event. Is this correct?

[RuralGuy]

Absolutely correct! Post the code here starting with Private Sub and finish at End Sub

[nkenney]

Private Sub menu3_Click()
On Error GoTo Err_menu3_Click
Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Item Code"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_menu3_Click:
Exit Sub
Err_menu3_Click:
MsgBox Err.Description
Resume Exit_menu3_Click

End Sub

[rommelgenlight]

check your if have a form named exactly "item code". verify if it is correct. if not, change it. compile and run again.

[nkenney]

I have never compile a form before to get this to work. Is this new? How do I get it to compile?

Thanks!

[rommelgenlight]

my advice nkenny with your codes, actually what you've done is best practice however if you dont need to use DIM then don't.

anyway have you checked if you have a form exactly named "item code" ? if there is difference then change your stdocname to what is the real form name.

Compiling is not new. Compiling is also a way of checking if your codes are correct as checked by ms access application. This is also called debugging.

To do compiling, if you are in the microsoft visual basic environment on which you do your coding, go to Debug on the Menubar and click compile.

let me know if you have opened your item code form already.

[RuralGuy]

Put this code in place of the original code and see what happens.

Private Sub menu3_Click()
   On Error GoTo Err_menu3_Click
   Dim stDocName As String
   Dim stLinkCriteria As String
   MsgBox "The Click code is executing"
   stDocName = "Item Code"
   DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_menu3_Click:
   Exit Sub
Err_menu3_Click:
   MsgBox Err.Description
   Resume Exit_menu3_Click
End Sub

[rommelgenlight]

my advice nkenny with your codes, actually what you've done is best practice however if you dont need to use DIM then don't.

anyway have you checked if you have a form exactly named "item code" ? if there is difference then change your stdocname to what is the real form name.

Compiling is not new. Compiling is also a way of checking if your codes are correct as checked by ms access application. This is also called debugging.

To do compiling, if you are in the microsoft visual basic environment on which you do your coding, go to Debug on the Menubar and click compile.

let me know if you have opened your item code form already.

let us do this first.

[nkenney]

It compiled fine. I added the msgbox after my dim statement and nothing happened. Do I need to do something at the form? This looked simple but has gotten confusing.

[rommelgenlight]

what is the exact name of your table? maybe you could try to attach your db so I can check it.

[RuralGuy]

Did you enable code to run yet?

[nkenney]

What occured is I started with a database I did about 3 years ago for another client. It created a .mdb file. I could load it in with no problems and everything but the push button code worked fine.

Today, I decided to create a new database (.accdb file) and created On-Click push button code and it worked fine. My question, this will be a bit of a pain to recreate. I was wondering if there was something I could do to upgrade the database instead recreating it from scratch?

Thank you for all of your help!

[RuralGuy]

You can import the old db into your .accdb or simply run it from ac2007.