Data cannot be entered into subform

[Guest]

I have a main order form, with an order details subform, as well as a
shipment details subform.
I have orderID and shipperID related to the orders table.
When i go into the shipment subform from my order form, for some reason i
can't edit or add any information to the shipment details record.
At one point i could, because some data is present, but i seem to have
messed things up.

Before things stopped working, i added a quantity field from order details
to my shipment subform as well as the shipping company name from the orders
table.

Now, the order details and shipping details arent directly related so i
thought this may be the cause of the problem, so i removed the quantity field
from my form to try and go back to how it was. But it still won't edit.

I tried to recreate my subform the same way i did the first time now it
doesn't link the order id's properly and won't bring up relevant records from
the shipment details table, and when i do enter new information, it doesnt
get inputted into the table.

I hope my explanation wasn't too confusing, hope someone can help.
Thank you

 

[Allen Browne]

1. Open the main form in design view.

2. Right-click the edge of the subform control, and choose Properties.

3. On the Data tab of the Properites box, make sure Enabled is Yes, and
Locked is No.

4. Click the upper left corner inside the subform control, so the title bar
of the Properties box reads Form. On the Data tab, make sure Allow Edits is
Yes, and Data Entry is No.

If all of that is correct, is the subform based on a query? If so, open the
query, and see if you can edit the records there. If not, you will need to
change the query until it is updatable.

Here's a list of things that commonly make a query read-only:

.. It has a GROUP BY clause (totals query).
.. It has a TRANSFORM clause (crosstab query).
.. It contains a DISTINCT predicate.
.. It uses First(), Sum(), Max(), Count(), etc. in the SELECT clause
(performs aggregation).
.. It involves a UNION.
.. It has a subquery in the SELECT clause.
.. It uses JOINs of different directions on multiple tables in the FROM
clause.
.. The query is based on another query that is read-only (stacked query.)
.. Your permissions are read-only (Access security.)
.. The database is opened read-only, or the file attributes are read-only, or
the database is on read-only media (e.g. CD-ROM, network drive without write
privileges.)