e-mail Current Form Record as a Report & Menu Solutions

[Marks]

Right I'm don't feel so nervous tackling VB as much now but basic stuff I'm great with so the next part of my script is:

1. Having a Front Menu. When you enter the number 1 in a textfield it selects formA, number 2 selects formB etc how would I do this?

2. E-mail Current Form Record. I found a similar thread to this but I used its code and it didn't work anyone got any ideas, I've managed to create one for Printing but not mailing any help would be appreciated!

[Nathan H]

Right I'm don't feel so nervous tackling VB as much now but basic stuff I'm great with so the next part of my script is:

1. Having a Front Menu. When you enter the number 1 in a textfield it selects formA, number 2 selects formB etc how would I do this?

2. E-mail Current Form Record. I found a similar thread to this but I used its code and it didn't work anyone got any ideas, I've managed to create one for Printing but not mailing any help would be appreciated!

Mark,

Something along this line would work for question 1.

This takes the value in a text box (txt1) and selects a form based on the value. I put this code on a command button

[Code = vb]
Private Sub Command0_Click()
If txt1 = "1" Then DoCmd.OpenForm "FormA"
If txt1 = "2" Then DoCmd.OpenForm "FormB"
End Sub
[/code]

Nathan

[Marks]

Mark,

Something along this line would work for question 1.

This takes the value in a text box (txt1) and selects a form based on the value. I put this code on a command button

[Code = vb]
Private Sub Command0_Click()
If txt1 = "1" Then DoCmd.OpenForm "FormA"
If txt1 = "2" Then DoCmd.OpenForm "FormB"
End Sub
[/code]

Nathan

Thanks Nathan, I stuck it it as onEnter instead of a Command Button and it works like a charm :) Many thanks and Merry Christmas :D

[missinglinq]

The OnEnter of what? Be aware that OnEnter will only fire if your user(s) tab into a control, not if they use the mouse and click into it. OnEnter events really should only be used to do things related to that particular control, not to fire code for such things as opening forms. If you always want a form to open when you enter data into txt1, it's AfterUpdate event would be more appropriate.

As for the emailing problem, you ought to post the code that you've tried.

Linq ;0)>

[Marks]

REF: e-mail Current Form Record as a Report

I've deleted the code because it was just being way to messy so if anyone has a code from scratch that would be fantastic :)

[Marks]

Found solution to this just had to modify the code a little