Form with subform - On selection data keeps changing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was wondering if someone could help me out with an Access Db problem.

The issue seems to be with the form which has 2 combo boxes (Product &
Division) for selection that feed into a subform (Parent/child rel.). When I
do a selection on the Product or Division, it brings the reqd. records and
if I close it and go back I see that it has added one more record. By looking
at the table I found that it changed the value of another reord, thus it
writes back to the table. Thereby changing the records in the table.

What I need is that it should bring back the required data set based on the
selection, and not alter or change these as its doing right now.

I would very much appreciate if you could point me in the right direction,
and thanks in advance for your input.
 
Combo boxes used for filtering/searching MUST be unbound. They cannot do
double duty as bound, updatable fields. You will need to add additional
controls to the form if you want to be able to update these fields in
existing records.
 
Back
Top