Accessing a Form from a button on a Form

  • Thread starter Thread starter gwmurray
  • Start date Start date
G

gwmurray

Hi Folks, this is what I'm trying to do... Any help would be greatl
appreciated.

I am using the default form that comes with Access 2000. They have
"Contacts" form that is the base form for the client data. In th
database i'm building I need about 4 different forms....
A "Screening" Form a "Face" Form a "Contact" Form and a "Cas
Narrative" form. In an effort to make it easy to access these forms
have created buttons with these names at the bottom of the "Contact
form... What I would like to know how to do is how to link thes
buttons to their designated forms once clicked. I have created th
forms in the Forms menu, but I don't know how to link them. Is there
simple VB command such as GoToForm "whatever" that I can attach t
these buttons? Please be descriptive, this is my first MS access dbas
so i'm not to effecient at it yet. Thanks in advanced for your help!!
 
Alright folks, I have been able to fix this problem partially... here i
the command I have added to my button:

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
DoCmd.OpenForm "Face_Form"

This command works like a champ, opens the Face Form and autofills th
number of the current record from the screening page. one sligh
hitch... It opens Face_Form in a hole different windows... Anyway t
add a type of command such as : DoCmd.CloseForm "Screen" after th
DoCmd.OpenForm "Face_Form" line? I don't want multiple windows open,
want it to open in the current window. Any help, again, is very muc
appreciated. ;
 
gwmurray said:
Hi Folks, this is what I'm trying to do... Any help would be greatly
appreciated.

I am using the default form that comes with Access 2000. They have a
"Contacts" form that is the base form for the client data. In the
database i'm building I need about 4 different forms....
A "Screening" Form a "Face" Form a "Contact" Form and a "Case
Narrative" form. In an effort to make it easy to access these forms I
have created buttons with these names at the bottom of the "Contact"
form... What I would like to know how to do is how to link these
buttons to their designated forms once clicked. I have created the
forms in the Forms menu, but I don't know how to link them. Is there a
simple VB command such as GoToForm "whatever" that I can attach to
these buttons? Please be descriptive, this is my first MS access dbase
so i'm not to effecient at it yet. Thanks in advanced for your help!!!
Click to expand...

I would suggest that those forms belong on the main form.
You can drag and drop them on if there is room or you could add a tab
control to make it look neat.
 
Back
Top