Form no longer allows data entry

  • Thread starter Thread starter jwr
  • Start date Start date
J

jwr

I have a products form with 302 items in it.

Now, for what reason I cannot find, will not allow any entries.

There are no locks on records. The field that reads data entry is set to
no. When I change it to yes and open the form, the 302 products are no
longer there.

Help please!
JR
 
Data entry means "only allow new records; don't show any existing ones"

How about the Allow Additions property? If it is set to No, you cannot add
records.
 
the DataEntry property is confusing. its' purpose is to allow the form to be
used *only* to enter NEW records, without displaying existing records. so
DataEntry = Yes means you don't see existing records, and DataEntry=No means
you do see existing records.

here's a couple things to check in form design view: is the AllowAdditions
property set to Yes? is the Recordset Type property set to Dynaset? is the
RecordSource property set to the name of a table? or to the name of a query?
if it's a query, can you open the query directly from the database window
(not through the form), and add new records?

hth
 
The AllowAdditions is Yes; Recordset Type is Dynaset; Recordsource is a
query.

The query does not allow additions either EXCEPT in 2 fields, SIN and
ContractNum. This is also the case with the form. I have checked the
properties of all fields and cannot see any difference.

Following is the SQL of the query:


SELECT Products.ProductID, Products.ProductName, Products.UnitPrice,
Products.ProductCode, Products.UnitWeight, Products.HandlingPct, SIN.SIN,
Contracts.ContractNum
FROM Contracts INNER JOIN (SIN INNER JOIN Products ON SIN.SINID =
Products.SINID) ON Contracts.ContractID = Products.ContractID;
 
some multi-table queries do not allow addition of new records. depends on
how the tables are related. what is the business relationship between those
three tables, and what kind of relationship links each pair of tables -
one-to-one, one-to-many?
 
Back
Top