MS Access Referencing Forms Using Module

10-15-2004, 11:27 AM
I have frmemployees and frmproducts (there are many more)
What I would like to do is create a module that will reference all of these forms so that when they open, they open to a new record (acnewrecord).

Any help is appreciated.

10-15-2004, 11:30 AM
Forms("Form_frmMain").Controls("txtFirstName") = "Joe"

This is how you reference the forms. Play around with the Intellisense to find the specific property you want to set, as that I don't know.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum