Data Entry Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chi - 20 Mar 2008 18:47 GMT

Hi,

I created a form to use for viewing currently records and entering new data.

This time, the form doesn't allow me to enter new data. In fact, all text
boxes didn't let me to enter new information.

Please help
Thanks
Chi

Reply to this Message

Klatuu - 20 Mar 2008 20:05 GMT

Several things to check:

In form properties:
Allow Additions = Yes
Allow Edits = Yes

If the form's record source is a query, be sure the query is updatable.

Signature

Dave Hargis, Microsoft Access MVP

> Hi,
>
[quoted text clipped - 6 lines]
> Thanks
> Chi

Reply to this Message

John W. Vinson - 20 Mar 2008 20:41 GMT

>Hi,
>
>I created a form to use for viewing currently records and entering new data.
>
>This time, the form doesn't allow me to enter new data. In fact, all text
>boxes didn't let me to enter new information.

What is the Recordsource of the form? If it's a Query, check to see if the
query is updateable. If it's not, search the help for "updateable" to find
some possible reasons, or open the query in SQL view and post the SQL text
here.

Signature

John W. Vinson [MVP]

Reply to this Message

Linq Adams - 21 Mar 2008 03:25 GMT

If, in fact, you can't update the query, have a look at Allen Browne's short
explanation here:

http://allenbrowne.com/ser-61.html

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Reply to this Message