Pop-up Box

[Andre Adams]

Hey guys.

I've searched through the threads unable to find something that would
specifically pertain to this situation. I'm running a client Account table
that's linked to the "Money Manager" table usng the "look-up" wizard. Upon
opening the account, is it possible that once the Manager's name is put in,
before it will allow you to tab I can put in a pop up to tell users what this
account will require. i.e "no confirms", "no statements"....

Please let me know.

Andre Adams

 

[Ryan]

You could create a form for manager and name it the managers name. In each
form specify the requirements with labels or textboxes on the form. Then in
the Before Update event of your Manager's Name field, you could place this
code.

Dim ManagersName as string
ManagersName = Me.NameOfTheControlYouPutTheManagersNameIn
DoCmd.OpenForm "ManagersName"

This would open the form with the list of requirements for that manager.
There are ways to do this with parameter queries so that you wouldnt have to
make a new form for each manager, but without the design of your tables I
wouldnt be able to give that example.