form does not accept data?

[Ed]

I have a form that draws name and other info from one table and then is
supposed to assign new data to one of four tables related to it. Form brings
up names from the list but when I try to enter in new data, it just beeps at
me. I can enter data via subdatasheets, but not via the form. Any thoughts?

Thanks.

 

[Ed]

Thanks for the response, RG.

Does that mean that one or more of the four tables is not updateable? If
so, is that a function of the form or the table. Not sure of where to make
the change.

 

[Ed]

Sorry if I'm taxing your patience at this point, RG, but you're taking me in
a whole new direction at this point. So let me ask a couple of things.

Are forms "by default" queries? I looked at the link you provided but it
spoke only of queries and so I don't know how to check those items in a form.

I haven't been able to find a "unique value" option so far. Any hints to
where that would be from a form perspective?

Thanks so much for this help. I've been wrestling with this for months.

Queries can be non-updateable. Tables do not suffer the same problem. I
would examine your query carefully looking for elements described in the link
I supplied.

Thanks for the response, RG.

Does that mean that one or more of the four tables is not updateable? If
so, is that a function of the form or the table. Not sure of where to make
the change.

It sounds like your form is bound to a non-updateable recordset.
http://allenbrowne.com/ser-61.html

[quoted text clipped - 5 lines]

Thanks.

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com

 

[Ed]

Using ACCESS 2003 (it was the new version when I first put this database
together).

When I look at the properties for any of the fields on the form there is no
RecordSource on any of the tabs. There's a Control Source on the data tab,
and it reads the same as the field name.

Forms are not queries. Forms can display the results of queries or tables.
On the Data tab of the property sheet for the form is the RecordSource. It
sounds like that is a query and it is not updateable. You can press the "...
" button to look at the query with the query builder. What version of Access
are you using?

Sorry if I'm taxing your patience at this point, RG, but you're taking me in
a whole new direction at this point. So let me ask a couple of things.

Are forms "by default" queries? I looked at the link you provided but it
spoke only of queries and so I don't know how to check those items in a form.

I haven't been able to find a "unique value" option so far. Any hints to
where that would be from a form perspective?

Thanks so much for this help. I've been wrestling with this for months.

Queries can be non-updateable. Tables do not suffer the same problem. I
would examine your query carefully looking for elements described in the link

[quoted text clipped - 11 lines]

Thanks.

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com

 

[Rick Brandt]

Using ACCESS 2003 (it was the new version when I first put this
database together).

When I look at the properties for any of the fields on the form there
is no RecordSource on any of the tabs. There's a Control Source on
the data tab, and it reads the same as the field name.

You are looking at properties of controls on the form. You need to look at
the properties of the fomr itself.

A query containing four tables has almost no chance of allowing edits. Use
a form with subforms with each one bound to a single table.