Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.
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.
Asked:
-
5
3
1 Solution
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.
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.
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??
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.
Tackle projects and never again get stuck behind a technical roadblock.
Join Now