subform data changes after each line input

[paulsparrow]

In my subform I enter the data through text box entries as well as
combo box selections. After I finish a line and go to the next one
when I select in a combo box my selection is cascaded up to all the
previous selections.

The data from the previous lines is entered into the tables correctly
it just gets changed in the view of the subform.

Sorry I am new to Access programming. Any help

 

[Guest]

Paul,

It sounds like the combo box is unbound. In design view (of the form) look
at the combo box. Open properties. Click on the DATA tab. The "Control
Source" property is the field the data is stored in. If it is blank, the
combo box is unbound.

The "Row Source" property is where the dropdown gets the data to be
selected. If this is blank, there are no items in the dropdown list to select.


HTH

 

[paulsparrow]

Paul,

It sounds like the combo box is unbound. In design view (of the form) look
at the combo box. Open properties. Click on the DATA tab. The "Control
Source" property is the field the data is stored in. If it is blank, the
combo box is unbound.

The "Row Source" property is where the dropdown gets the data to be
selected. If this is blank, there are no items in the dropdown list to select.

HTH

No the boxes are all bound are the data entered is going into the
proper tables and cells. What is happening is after entering the data
for the first record I go to the next line (next record) and as soon
as I enter any data it changes all the previous records to match.
This does not affect the data in the tables only on the subform
screen.

Attached jpeg:
http://surreyfootball.com/access.jpg

 

[paulsparrow]

No the boxes are all bound are the data entered is going into the
proper tables and cells. What is happening is after entering the data
for the first record I go to the next line (next record) and as soon
as I enter any data it changes all the previous records to match.
This does not affect the data in the tables only on the subform
screen.

Attached jpeg:http://surreyfootball.com/access.jpg

Steve you are correct. I bound the combo_box and it works now. My
only issue is that the subform writes to a table that did not include
that field so I had to add it making it redundant in my data base.
Well for now it works. Thanks.