Control Box visible

[stuartford]

i need the control box(X) to become visible from my code.
normally it would be turned off but on one form if the criteria isnt met on load i would like it to be visible

i have tried
Forms.ControlBox = True

but it dont work
any ideas?

Cheers Stuart

 

[Norie]

Do you mean the close button on a form?

When do you want to make it visible?

Have you tried this:

Me.ControlBox = True

 

[stuartford]

yeah the close box

i want it top be visible on form open when the if statment i have is run

and i have tried the me.controlbox=true
and it dont work
Cheers
Stu

 

[Norie]

Stu

I tried Forms("Form1").ControlBox = True in various events (Activate, Open, Load) and either got a 'can't set value' error or nothing happened at all.

What are you actually trying to do?

 

[stuartford]

i have a form with various text boxes on it
a query opens the form bassed on a date and product code entered the relavant info is populated on the form bassed on this.

if an incorrect date / or prod code is entered the form will have nothing populated.

as this is a change of deliverys concession form the close button is disabled because the user has to use a command button that records any changes that have been made and the user (via environ) that did it

if the wrong data is entered i would like the close button to be re enabled.

i suppose after the check for blank fields i could just close the form compleatly and get the user to start again.

would that be with docmd.close?

Stu

 

[stuartford]

cheers for ya help
ive got it close the form if the criterias not met

Thanks Stu

 

[Norie]

i suppose after the check for blank fields i could just close the form compleatly and get the user to start again.

would that be with docmd.close?

That sounds like the best idea and I think code would work though you might try this instead just to be sure:

DoCmd.Close acForm, Me.Name