Editing Records in a Form

[Deleted member 28156]

Hi all
At the moment I have a form which links to a table, one of the columns in the table is called "Description" so the user can input a sentence or two. Basically I when I open this form (in Edit Mode as Im using a Switch Board)it will not allow me to edit a current record.

I can edit a record in the tabel but not in the form.... .. help

Any help would be superb

Cheers

 

[ScottGem]

Hi all
At the moment I have a form which links to a table, one of the columns in the table is called "Description" so the user can input a sentence or two. Basically I when I open this form (in Edit Mode as Im using a Switch Board)it will not allow me to edit a current record.

I can edit a record in the tabel but not in the form.... .. help

Any help would be superb

Cheers

What is the recordsource of the form? What happens when you try to edit the record? Is it just the Description control that is a problem? Did you check the Allow Edits property of the form or the Enable and Locked properties of the control?

 

[iago18]

Make sure the Primary Key of the table you are editing is part of the query for the form. Also, yes: check the AllowEdits property of the form.