467,875 Members | 1,418 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,875 developers. It's quick & easy.

Form for entering data into linked Table

Catalyst159
100+
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.
Feb 21 '12 #1

✓ answered by NeoPa

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

  • viewed: 2527
Share:
10 Replies
NeoPa
Expert Mod 16PB
You need to make sure the underlying recordset is updatable and ensure AllowAdditions is set to True.
Feb 22 '12 #2
512MB
Also AllowEdits must be set to true.
Feb 22 '12 #3
Catalyst159
100+
Is AllowAdditions found under the forms properties?

Is AllowEdits found under the forms properties?
Feb 22 '12 #4
Catalyst159
100+
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.
Feb 22 '12 #5
512MB
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.
Feb 22 '12 #6
NeoPa
Expert Mod 16PB
Please check Reasons for a Query to be Non-Updatable if your record source is not updatable.
Feb 22 '12 #7
Catalyst159
100+
I am getting the following message:

"This recordset is not Updateable."

Is there anyway to make it updateable?
Feb 22 '12 #8
NeoPa
Expert Mod 16PB
I hope you're not easily embarrassed, but look back one post and follow the link.
Feb 22 '12 #9
Catalyst159
100+
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.
Feb 22 '12 #10
NeoPa
Expert Mod 16PB
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 ;-)
Feb 23 '12 #11

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Annette Massie | last post: by
3 posts views Thread by Michael Plant | last post: by
reply views Thread by ericellsworth | last post: by
reply views Thread by crypto_solid via AccessMonster.com | last post: by
reply views Thread by jack112 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.