Testing for mode form was opened in

[JSMiami]

The switchboard has a way of opening forms in either Add mode or in
Edit mode. Is there anyway of testing for that mode in VB code? If not
is there a way of testing (within a subform) if there is a parent?

Thanks

[Terry Kreft]

1) Check the DataEntry Property of the form

2) Look at the parent property, if a form obkject is a subform then its
..Parent property will return an object, if it isn't then referring to its
..Parent property will return a trappable error (2452)

--
Terry Kreft
MVP Microsoft Access
"JSMiami" <js*****@unete.com> wrote in message
news:44**************************@posting.google.c om...

The switchboard has a way of opening forms in either Add mode or in
Edit mode. Is there anyway of testing for that mode in VB code? If not
is there a way of testing (within a subform) if there is a parent?

Thanks

[Dave Perry]

js*****@unete.com (JSMiami) wrote in message news:<44**************************@posting.google. com>...

The switchboard has a way of opening forms in either Add mode or in
Edit mode. Is there anyway of testing for that mode in VB code? If not
is there a way of testing (within a subform) if there is a parent?

Thanks

JSMiami,

You may want to take a look at SysCmd function and the
acSysCmdGetObjectState argument, with a very good article at:

http://builder.com.com/5100-6386-5069824.html

-dp