Form for entering data into linked Table

[Catalyst159]

I have a linked table called "dbo_tblNotes".

dbo_tblNotes has the following fields:

id (Data Type = Number, Indexed = No)
note (Data Type = Memo)
addDate (Data Type = Date/Time)
uid (Data Type = Text)
private (Data Type = Number)

I am trying to create a form that I can use to enter notes and comments. Any notes that are entered would be stored in the "dbo_tblNotes" table under the "note" field. I only want the form to be used for entering or changing notes. I have tried creating a form based on the "dbo_tblNotes" table but I am unable to enter anything into Notes. It only displays the notes for each record.

Any help would be greatly appreciated. Thanks in advance.

[NeoPa]

You need to make sure the underlying recordset is updatable and ensure AllowAdditions is set to True.

[Mihail]

Also AllowEdits must be set to true.

[Catalyst159]

Is AllowAdditions found under the forms properties?

Is AllowEdits found under the forms properties?

[Catalyst159]

How could I make sure that the underlying recordset is updateable?

I have checked the AllowAdditions and AllowEdits options and they are indeed set to True, but still I am unable to enter or edit the note.

[Mihail]

If your form is bounded to a table then the recordset IS updatable.
If the form is bound to a query, run the query, then try to make a change in the "note" field.
If you can do that then the recordset is updatable.
If can't the recordset is not updatable.

If the recordset is updatable I can see only one reason for why you can't edit the "note" field:
The text box for notes is locked.
So... unlock it.

[NeoPa]

Please check Reasons for a Query to be Non-Updatable if your record source is not updatable.

[Catalyst159]

I am getting the following message:

"This recordset is not Updateable."

Is there anyway to make it updateable?

[NeoPa]

I hope you're not easily embarrassed, but look back one post and follow the link.

[Catalyst159]

What do you mean? I did check out the link. Why would I be embarassed?

- Ok so I needed delete the linked table then re-link the table but this time choose the "id" field as a unique identifier.

[NeoPa]

Catalyst159:
What do you mean? I did check out the link. Why would I be embarassed?

Because you asked a question in one post which had already been answered in the previous one. You may have some rationale for that, but this is a public forum and it doesn't look too clever ;-)