Re: [MSAccessProfessionals] Form question

I would open the form's recordsource in datasheet view to determine if records can be added. Then check the form's data properties. 

Duane 

Sent from my mobile

On Jul 2, 2024, at 3:17 PM, bbdkthomas <dthomas@argraffcorp.com> wrote:

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

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.

[MSAccessProfessionals] Form question

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

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116625) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_