unable to enter data on form. help?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

miowka - 18 Dec 2007 11:50 GMT

I have created a form using a relationship between two tables. This was to be
a data entry form but when I try to enter data nothing happens. The cursor
moves to the first field but typing doesn't result in data appearing on the
screen. I could do with some help

Reply to this Message

Allen Browne - 18 Dec 2007 12:02 GMT

It sounds like you have based the form on a non-updatable query.

For a list of why this might be so, see:
Why is my query read-only?
at:
http://allenbrowne.com/ser-61.html

There are other possible explanations, e.g.:
- you set the form's AllowEdits property to No
- you set the form's Recordset Type property to something other than
Dynaset.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have created a form using a relationship between two tables. This was to
>be
> a data entry form but when I try to enter data nothing happens. The cursor
> moves to the first field but typing doesn't result in data appearing on
> the
> screen. I could do with some help

Reply to this Message