Creating a template letter/Report via dropdown menu & pop-up table

[dohernan]

Good afternoon.

I have a table called PersonnelForms2009 with a Field called ‘Form Type’
that’s a dropdown menu.

I want to be able, if a person is entering the record in Table/Datasheet
view, or using the Form to input new Records, to have another table pop up if
the person selects “Verification†from the dropdown menu, because
Verifications are letters, and at that point I would need more information.
(Right now I leave Access and go to Word, where I have a Verification letter
template complete with header & footer, and open up another program in order
to get addresses.)

The original Table has the employee Last & First names, and the Socials.
In order to generate the letter I would need to get further information such
as-

Dates of Employment:
Title:
Salary:
Last Known Address:

And a paragraph left blank in case there are extra Notes to add to the
bottom of the letter.
I also want to be asked if I want to add another sentence to the letter
“Actual Start Date†if I do then I would need to be able to input that date
as well.

I would want the 2nd pop-up table to keep the addresses in case the same
person needs a letter at a later date. I figured the 2 tables could be
related by the Social Sec # Fields.

Is it possible to print envelopes from Access using the letter/report once
it's generated?

In some cases the employee doesn’t want their social printed, or their
address has to show up as N/A, so if the address/city/state/zip fields are
blank I want N/A to show up.

Once a letter is printed I’d like the Completed field in the original table
to show the current date as the Completed date.

Any help would be appreciated, even a link in the right direction, thanks
so much.

 

[PieterLinden via AccessMonster.com]

Good afternoon.

I have a table called PersonnelForms2009 with a Field called ‘Form Type’
that’s a dropdown menu.

I want to be able, if a person is entering the record in Table/Datasheet
view, or using the Form to input new Records, to have another table pop up if
the person selects “Verification†from the dropdown menu,

Stop for a second. Tables in Access expose no events that you can hook into.
Forms on the other hand have LOTS of them. So hide the tables so users
cannot enter data into them directly. Make them (whether they like it or not)
use forms.

Doing this kind of thing in forms is child's play. In the AfterUpdate event
of the control, put some code ...

If Me.Value = "Verification" Then
DoCmd.OpenForm "MyForm"...
End If

And have the form open as modal/dialog (so the user MUST respond).

 

[dohernan]

I tried that Macro and got
"The If Me Macro or group doesn't exist"

am I supposed to keep the ... after the form name?

I am new to Access so I don't consider this child's play.

Thanks