Cannot Get Blank Form To Open For NEW Data Entry

[Shayster]

We have created several forms for sales order entries and have set them all
to "yes" on data entry. This has worked well for all forms but one. When we
open the form in question, we get all of our previous data, but it doesn't
allow us to get a new blank form to enter new data. We have removed the
"yes" on data entry, and still have the same issue. For that matter, the
"yes" on data entry, never worked in the first place, we never got blank
records. Before we made the "yes" to data entry change, we did already have
data in our form.

 

[Piet Linden]

We have created several forms for sales order entries and have set them all
to "yes" on data entry.  This has worked well for all forms but one.  When we
open the form in question, we get all of our previous data, but it doesn't
allow us to get a new blank form to enter new data.  We have removed the
"yes" on data entry, and still have the same issue.  For that matter, the
"yes" on data entry, never worked in the first place, we never got blank
records.  Before we made the "yes" to data entry change, we did alreadyhave
data in our form.

What is the form using as a recordsource? A table or a query? If
it's a query, is it updateable? (Usually, if the query is based on
more than one table, it's not updateable).

 

[Beetle]

It could be that you have based you form on a read only
recordset, like a Totals query, or a query joining multiple
tables, in which case the Data Entry property would have
no effect and you would not be able to add new records.

Have you ever been able to add new records to this form?

If so, has the record source changed recently?

 

[Shayster]

Hi...we do have the forms going into multiple queries which ultimately go
into a Union Query, but the other forms that feed all of the queries are not
having this issue. I don't think that we have changed the record source, but
I will check to see if maybe we did. Thanks for your reply.

 

[Piet Linden]

What is the recordsource for the form that is not working? If it is a
non-updateable query, then that's your problem.

 

[Shayster]

It's not the query that we are having read only issues with it's the Form
itself that will not allow us to enter new data...the thing is that we have 5
other forms that are not having this issue...thanks for the Allen Browne
link, I will keep that for future reference.

 

[Beetle]

So if you open the query directly you can add new records
to it?

 

[Shayster]

We have fixed our issue! It was related to a qery that had a "Group By"
clause in it...once removed the Form does what we want it to now...Thanks for
the suggestiosn!