Access 2010-Modal Dialog Forms (1 Viewer)

mclinger72 · Jun 19, 2013

Hello,

My name is Meredith and I work in healthcare as a Physician Credentialing Specialist. I am VERY new to Access (2010) but I am a quick learner. I have multiple tables with physician information and have 2 main forms which are modal dialog. I have 63 physicians which I use the navigation bar for to go between. What I want to know is: When I am working in Form 1 on physician 23, and hit my command button to go to Form 2, how do I get form 2 to open to physician 23 or whichever physician I happen to be working on?

rzw0wr · Jun 19, 2013

Docmd.openform "frmName",,,,acFormEdit,acWindowNormal,OpenArgs

Put the Physician's id in the open args.

A string expression. This expression is used to set the form's OpenArgs property. This setting can then be used by code in a form module, such as the Open event procedure. The OpenArgs property can also be referred to in macros and expressions. For example, suppose that the form you open is a continuous-form list of clients. If you want the focus to move to a specific client record when the form opens, you can specify the client name with the OpenArgs argument, and then use the FindRecord method to move the focus to the record for the client with the specified name.

Dale

mclinger72 · Jun 19, 2013

Thanks for replying Dale. But since I am a newbie to Access as well, can you break it down further from me!

Access 2010-Modal Dialog Forms (1 Viewer)

mclinger72

New member

rzw0wr

I will always be a newbie

mclinger72

New member

Similar threads

Users who are viewing this thread