data entry form not blank anymore

[Guest]

Hi,

I changed the query that ran my data entry form and now it opens up with
data populated in it. I looked at my query and noticed that there is no line
at the bottom where i can add new records. Is this my problem?

How can I fix it so my form is a data entry form only again? I already have
it set to 'yes' on the 'data entry' property.

thanks,

 

[Douglas J. Steele]

If there's no blank line at the bottom of the query, that implies that the
query is read-only. If that's the case, then there's no way to make the form
updatable: you have to make the query updatable.

What type of query is it? Are you using DISTINCT in it? Are you using domain
aggregate functions such as Count() or Sum()? Are you joining together
multiple tables?

It would probably help if you posted the SQL of the query. (If you're not
familiar with working with the SQL that Access generates, open the query in
Design View, then select SQL View from the View menu)

 

[RBear3]

You changed the query in what way? Sounds like you created a query through
which records can't be added. Are there multiple tables in this query? My
guess is that you have a relationship that you can't use within a query if
you want to add records through it.

 

[Guest]

I added a new table to the db. My query consists of many left joins... I
checked the sql views for each and all are set to no locks.

Is it because I have a bunch of left joins?

Here is the heirarchy of my queries:

1. SELECT RegStates.*, Company.Company_ID, Company.Company_Name
FROM Company INNER JOIN RegStates ON Company.Company_ID = RegStates.Company;

2. SELECT CompanyQry.*, OpDistrict.OpDistID, OpDistrict.District
FROM CompanyQry LEFT JOIN OpDistrict ON
CompanyQry.Company_ID=OpDistrict.Company_ID;

3. SELECT Districtqry.*, Lease.LeaseID, Lease.LeaseName, Lease.LeaseNumber
FROM Districtqry LEFT JOIN Lease ON Districtqry.OpDistID=Lease.OpDistID;

4. SELECT Leaseqry.*, Wells.*
FROM Leaseqry LEFT JOIN Wells ON Leaseqry.LeaseID=Wells.Lease;

Does this make sense?

Thanks