form does not accept data?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ed - 24 Mar 2008 16:28 GMT

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.

Reply to this Message

ruralguy - 24 Mar 2008 16:56 GMT

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

>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.

Signature

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

Reply to this Message

Ed - 24 Mar 2008 17:24 GMT

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.

Reply to this Message

ruralguy - 24 Mar 2008 18:37 GMT

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.
>
[quoted text clipped - 7 lines]
>> >
>> >Thanks.

Signature

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

Reply to this Message

Ed - 24 Mar 2008 20:48 GMT

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.

Reply to this Message

ruralguy - 24 Mar 2008 21:22 GMT

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.
[quoted text clipped - 12 lines]
>> >> >
>> >> >Thanks.

Signature

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

Reply to this Message

Ed - 24 Mar 2008 21:53 GMT

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
[quoted text clipped - 18 lines]
> >> >> >
> >> >> >Thanks.

Reply to this Message

Rick Brandt - 25 Mar 2008 00:13 GMT

> 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.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message