Solved What is locking my form?

[lacampeona]

OK I will think what to do i will do a lot of testing
I am entering into new entry from some another form. They are connected.
Becouse of that I set Data entry to Yes...but now i am thinking to make some button so the user will click that button to enter new data.
ohhh i just wanted to be more easier for the user and it seem that then is more complicated for me.
thank you

 

[lacampeona]

Well I think that my situation is very complicated. But I will try what you all suggest me today. To set Data entry to No.

I need that users always when choosing records from form A and when going to the form B to enter data like new record. User just need to enter data.

If he want to see previus specific ID record he choose the specific ID record and opened in. If the record is approved then all the fields form that specific ID are locked, so in that specific ID record he can not change data anymore.

1. User enter new data in form A
2. In form A is some buttonA who say Use that item A for something ( usage of some item)
3. User click the buttonA and open form B ( here the form must be empty, he must enter new record) with some another buttons, one imortant is button sign record let say button C
4. User enters all the data in the form B and then he click the button C and first sign the record
5. then came approver he open specific record that mean form B and he also click the button C to sign the record- he approved the record
6. if user want to check if all is signed and locked- he click again the form B he choose the specific ID record and check the data

what is best correct approach to make that? I will try like you suggest me, I am just wondering if you experts would like do that in another way.

Now I have in the same way like I described, but becouse sometimes the forms go locked ( I have to find what is the problem) I just start to use on Load event code to go automaticly to add new data, then with a lot of testing realise that the problem is now in the load event
So i delete load event and now again the form is working but sometimes is locked and sometimes no..hmmmmm

ohhhh

 

[lacampeona]

I am just testing and for now i am using some button to open a form in add mode
hmmm i still have to try all the suggestions from Pat
and I think my problem is the same like here:

https://www.access-programmers.co.uk/forums/threads/open-form-to-add-mode-or-edit-mode.295855/

 

[gemma-the-husky]

The point was that setting DataEntry = NO (the default) is not normally an error and does NOT mean that you cannot add any new records.

Data Entry = YES, is for a special type of Data input form, where you might have clerks who need to enter new records, but never need to examine old records as part of that process. Hence, just a form for (new) Data Entry. Each time you open the form the record count for the current session starts again at Zero.

 

[lacampeona]

I have to say that I am very stupid.
I make a mistake and becouse of me the form was all the time locked.
When I have a record ID signed ( here all the field are disabled, greyed) then from that record I make another entry...and becouse I use AcFormEdit the fields were all disabled, only when I make the first record the field were empty and then all the time disabled. Becouse of that i was saying that sometimes is locked sometimes no.
I thought if I use DataEntry Yes the form will always open new entry. That was true but then with AcFormEdit i make the another mistake.
Now i change to AcFormAdd and I think I finally managed to work. I will make a lot of testing to confirm my conclusion. ohhhh
I am so sorry experts it was my fault.
Thank you to all for your suggestion.
I use Pat solution to use AcFormAdd and now seems ok and I also change DataEnty to No.