I have a number field Problem!

[Z1nkstar]

The Sort field is a number field that is supposed to be editable but I cant edit it in this screen I have to open the order and edit it there. My concern is that I don't want to have to open the up everytime to edit the value I want it to change when I change it.

[orange]

Can you provide a little more info on your tables and relationships? Simple, plain English.
Where is the SORT field stored? How does it get valued?

[Z1nkstar]

it was supposed to be where if you click on the number in the sort value it would allow you to change it but now it wouldn't let anyone change it until the record is opened in the second picture but I also have the same values on a different form but everything is the same as far as I can tell but on the other form I can change the value from the form in the first screen? I absolutely have no idea how that could have happened

[June7]

We need to know more about data relationships. What is the RecordSource of the form you want to edit?

If you want to provide db for analysis, follow instructions at bottom of my post.

[Z1nkstar]

DLDB.accdb
On Open
Username: Michael
Password: 062212
Navigate to Fabrication Tab
Click On Ruben
You should see Sort column
That’s where I can’t edit the number now go to Leo
(Same Numbering Values)
But I can edit the value on Leo Tab
To edit Values on Ruben Tab I have to double click to open form for editing it.

[Z1nkstar]

https://drive.google.com/file/d/0B2Y...it?usp=sharing
My bad didnt know theres a zip

[June7]

As db is set up, makes it difficult to review. Not easy to close objects from Design view. I find this quite annoying. I switched to Overlapping Windows option.

Also, the login uses code that is specific to 32-bit computers. I am using 64-bit. Instead of apiGetUserName, I just use Environ("USERNAME") to pull username from the network login.

The Ruben subform AllowEdits property is set to No.