Avatar billede omn Mester
07. november 2021 - 09:15 Der er 1 løsning

Records are locked.

I open a Continuous Forms
Pop up = No,
Modal = yes,
Record Locks = No record.
From this form I select a record and open a single form  with 
Pop up = No,
Modal = yes,
Record Locks = No record.
I change a field in single form and now I get a message "Cannot apply the filter because all records are locked". Data is saved so it works but I must get rid of this message. 
I have many other forms where it works but now i have this very strange situation for only this formular. In the Access File Tab I have checked that database is set in shared mode and no locks. 
Best Recards.
omo
Avatar billede Gustav Ekspert
07. november 2021 - 09:55 #1
Somehow your code locks the record, so double-check everything.
If you have a similar case where you don't see the message, compare with that to find any difference.
If everything fails, rebuild the two forms from scratch in steps, and check for each step that it works.
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Dyk ned i databasernes verden på et af vores praksisnære Access-kurser

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester