Event Procedure

[John Cello]

Ed:

The action you describe could be accomplished by either a
macro or code module. If you can open the form in design
mode, look at what the OnClick event property is. It will
either say [Event Procedure] or list a macro name. If it
is an [Event Procedure], click on the box with the 3 dots
on it and it will show you the code.

Hope this helps.

John Cello
John Cello Consulting
Communications For Business
www.johncelloconsulting.com

 

[Ed]

John thank you for the reply. On opening the properties ,on click event
propery, the program is showing code in visual basicss. I 'am very week in
this area and need assistance in writing prpoer code. I could give the names
of the table and main forms if you could help me.
Thanks Ed Price

Ed:

The action you describe could be accomplished by either a
macro or code module. If you can open the form in design
mode, look at what the OnClick event property is. It will
either say [Event Procedure] or list a macro name. If it
is an [Event Procedure], click on the box with the 3 dots
on it and it will show you the code.

Hope this helps.

John Cello
John Cello Consulting
Communications For Business
www.johncelloconsulting.com

-----Original Message-----
The database opens to a main form that asks for name and password. Then
proceed clicking on a button to open a form, if the name and password do not
equal a match from the table they were written from, the form does not open.
Question is this done by a macro or from the properties of the form button to
be opened and what wuold be the statement.

 

[John Cello]

Ed:

Sorry about the huge delay.

If you can copy and paste the code in here, I'll take a look at it.

John thank you for the reply. On opening the properties ,on click event
propery, the program is showing code in visual basicss. I 'am very week in
this area and need assistance in writing prpoer code. I could give the names
of the table and main forms if you could help me.
Thanks Ed Price

Ed:

The action you describe could be accomplished by either a
macro or code module. If you can open the form in design
mode, look at what the OnClick event property is. It will
either say [Event Procedure] or list a macro name. If it
is an [Event Procedure], click on the box with the 3 dots
on it and it will show you the code.

Hope this helps.

John Cello
John Cello Consulting
Communications For Business
www.johncelloconsulting.com

-----Original Message-----
The database opens to a main form that asks for name and password. Then
proceed clicking on a button to open a form, if the name and password do not
equal a match from the table they were written from, the form does not open.
Question is this done by a macro or from the properties of the form button to
be opened and what wuold be the statement.