Re: [MSAccessProfessionals] Form question

Check for possibilities of record locking.

If there is any possibility that the same table and data record is open and locked elsewhere in your application, this would be a normal symptom for that.

 

Check all open recordsets, forms/reports, queries, etc. for the possibility of having the same data row(s) open elsewhere and if there are pending writes, then when the focus shifts from that form check to see if there are pending data writes for the form by:

if me.dirty then... logic.

 

I will often fix this by putting:

if me.dirty then runcommand accmdsaverecord

in where the form can lose (mouse-/cursor-)focus/

 

This can prevent the record locks from causing this sort of problem.

i just helped another developer find this exact case arising in a database app on my recent project.

 

- Mark Burns

 

On 07/02/2024 4:16 PM EDT bbdkthomas <dthomas@argraffcorp.com> wrote:

 

 

I have a form that all of a sudden will not allow me to enter data into a field.