Access sub form help needed

[ang724]

I made a form that pulls information from a query. It works fine. I made a
subform that also pulls information from a query. Originally I used the same
query but thought that might have been my problem so I made a new query. The
subform it allows me to enter information on the first line but when I try to
enter information on the second line I get a box that says, "You can't assign
a value to this object. The object may be a control on a read only form.
The object may be on a form that is open in Design View. The value may be
too large for this field." I don't have anything open in Design View and the
boxes are not set to low numbers. I'm usually trying to enter a 1. I had it
set up with a quantity box first that I needed to enter a quantity then a
combo box to pull the info from the query. At first, I thought the problem
was the quantity box so I removed it and still go the message about not
assigning a value. I have checked to see that Enabled is on yes and allow
edits is on yes. I can override the box and enter the information on the
second line but when I close the form and reopen it the information is gone.
I have no idea what to do to get this to work right.

 

[golfinray]

First off, you need to know if you are trying to do a one-to-one relationship
in your from subform or a one-to-many? If you have a straight one-to-one (one
item the mainform for each item in the subform) then only one will come up. A
one-to-many relationship needs to be set up where the mainform is the one and
the subform is the many (One salesman, many products to sell.) Then your
mainform and subform have to be linked with a master-child link. So if say
employee ID were your key in the master(mainform) then employee id would be
what you wanted to be the key in the subform. Next, make sure both queries
are editable (the arrow and asterisk at the bottom are highlighted.)

 

[SANDRAGRIFFITH]

I made a form that pulls information from a query. It works fine. I made
a
subform that also pulls information from a query. Originally I used the
same
query but thought that might have been my problem so I made a new query.
The
subform it allows me to enter information on the first line but when I try
to
enter information on the second line I get a box that says, "You can't
assign
a value to this object. The object may be a control on a read only form.
The object may be on a form that is open in Design View. The value may be
too large for this field." I don't have anything open in Design View and
the
boxes are not set to low numbers. I'm usually trying to enter a 1. I had
it
set up with a quantity box first that I needed to enter a quantity then a
combo box to pull the info from the query. At first, I thought the
problem
was the quantity box so I removed it and still go the message about not
assigning a value. I have checked to see that Enabled is on yes and allow
edits is on yes. I can override the box and enter the information on the
second line but when I close the form and reopen it the information is
gone.
I have no idea what to do to get this to work right.