VBA for Access (Access 2000)

Topic

New Reply

Hi! This is my first post to this site, so sorry if I’m not specific enough. I’m writing a database in Access 2000, and I need to write code to open and display a form. I tried

Open (frmxyz)
Show (frmxyz)

but the complier gives me error messages. This is the first time I’ve used VBA, so I’m not real sure what to do, and none of the books or help files I look at seem to be helpful. TIA

Ruthie B
(SammyB’s daughter )
Bethel College

Reply | Quote

Replies

When in code you have to use the do command function:

On the EVENTS TAB insert this code:
docmd.OpenForm “NAME OF THE FORM”,acNormal

Reply | Quote

Thanks! I’ll give it a try.

Ruthie B
Bethel College

Reply | Quote