Patrick O'Dea
asked on
Add - Modify Data
Hi,
General high level question. (Must have arisen before).
I have simple table for "Supplier Details".
The data is UniqueSupplierCode, Name, Address, Email etc.
I want a SINGLE form which will allow me to Add new suppliers and modify existing ones.
How can I prevent the user from amending the UniqueSupplierCode once it has been set up.
They can obviously amend the name and address details etc.
I do not want to use autonumbering.
General high level question. (Must have arisen before).
I have simple table for "Supplier Details".
The data is UniqueSupplierCode, Name, Address, Email etc.
I want a SINGLE form which will allow me to Add new suppliers and modify existing ones.
How can I prevent the user from amending the UniqueSupplierCode once it has been set up.
They can obviously amend the name and address details etc.
I do not want to use autonumbering.
lock the control that display the UniqueSupplierCode
ASKER
Thanks capricorn1,
But if I lock the control then I will not be able to add NEW suppliers ?? true?
But if I lock the control then I will not be able to add NEW suppliers ?? true?
You can toggle the control to allow edits based on the NewRecord value. You'd do this in the Current event of the form:
Sub Form_Current()
Me.YourControl.Enabled = Me.NewRecord
Me.YourControl.Locked = Not Me.NewRecord
End Sub
This will Enable and Unlock your control when the form is in the "NewRecord" mode only.
Sub Form_Current()
Me.YourControl.Enabled = Me.NewRecord
Me.YourControl.Locked = Not Me.NewRecord
End Sub
This will Enable and Unlock your control when the form is in the "NewRecord" mode only.
ASKER
THanks LSM,
a perfect solution!
a perfect solution!
ASKER
oops, I thought I had closed this query and have since raise another query that relates to this one.
...The solution is not as perfect as I thought !
I need to be able to filter and sort on the data that is disable by this code;
Me.YourControl.Locked = Not Me.NewRecord
Anhy easy way to do this??
...The solution is not as perfect as I thought !
I need to be able to filter and sort on the data that is disable by this code;
Me.YourControl.Locked = Not Me.NewRecord
Anhy easy way to do this??
Whether the box is locked or enabled would have no impact on the Filtering, unless you're referring to the rightclick filter.
ASKER
yes , I am referring to the right click filter.
What is the best (simplest) way to get a filter on this field??
Can I re-activate my right click one??
What is the best (simplest) way to get a filter on this field??
Can I re-activate my right click one??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Got it now!
Thanks again
Thanks again