Closing form when you leave

[Fie]

hi,

How do you get form to close when u navigate away from it to another
form???

fie

 

[Lynn Trapp]

If you always navigate to the second form from the first one then you can
put the following code in the Activate event of the second form.

Forms!YourFirstForm.Visible = True

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Fie]

cheers chick

 

[Lynn Trapp]

Chick??? hmmmmmm... my wife's gonna wonder about that one... <g>

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Tom Ellison]

Dear Lynn:

You should see what happened to me when my wife saw that a nice lady had
posted thanks to me, calling me "sweetie". I knew nothing was going on, but
my wife didn't. Sadly, when I asked the poster to refrain from such terms,
she was so embarassed I never heard from her again. Very sad!

So, I know the feeling!

Tom Ellison

 

[Lynn Trapp]

Hi Tom.

I quite often send the posts where someone refers to me as a woman to my
wife. She gets a kick out of it.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Tom Ellison]

Dear Lynn:

I believe I remember making a similar mistake at one time myself a few years
ago. It didn't seem to shock you. Lynn is a perfectly good ambigenderous
name (I made up a new word!)

So, do the guys in the newsgroup often make passes at you? If they had seen
your beard, I think that might stop.

Tom Ellison