disabling fields in form

samer

Registered User.
Local time
Today, 18:03
Joined
Jan 27, 2004
Messages
38
I’ve form, it is a work order form, and usually it takes more than one day
To close the work order .So I am not going to use the data entry in the form
Property, because it will hide every thing the time I close the form.
I need a function such like on click the work order will be disabled , can any
One help .
 
samer,

You can use the button to:

Me.SomeControl.Enabled = False

Where SomeControl is the name of your object(s).

Wayne
 
WayneRyan said:
samer,

You can use the button to:

Me.SomeControl.Enabled = False

Where SomeControl is the name of your object(s).

Wayne

Thanks for replying to my question, but what is happening are this:
This form is a work order I may need keeping it open for some time.
But when the job is finish, I want to disable entering data into this
Job order,
I have got two work orders: 10010 & 10020
10010 is a finish work order I want to close it, I think by disabling
The form but:
I want to keep the 10020 open for more entries.
When I use your code I can close fields in WrkOrd 10010 which is
Finished, and it will close the 10020 too.
I want it to close certain WrkOrd with the whole fields into it, but not
The next WrkOrd.
Any help …..
 
Have one more field in the table called Locked and make it a yes/no field.

When the record is finally locked, set the control bound to the field to true.

In the form's current event put something like:

Code:
If Me.chkLocked Then
    Me.AllowEdits = False

Else
    Me.AllowEdits = True
End If
 
Question

How do I do this: set the control bound to the field to true. I am trying to employ the same concept.
 

Users who are viewing this thread

Back
Top Bottom