Subform in a form

[Guest]

I have a form with a subform that is changing my data in my table.

Here's the criteria:

1. Both forms are of the same table
2. The main form has two combo boxes and the data types are text. One
control source is named month and the other is named year.
3. Then I have the Subform within this form that is linked to customer name
, month and year.

My problem is when I switch back and for by months it's changing the data in
month. So if I'm in Jan and switch to Feb the Jan is now say Feb. Any idea
why?

 

[John Vinson]

I have a form with a subform that is changing my data in my table.

Here's the criteria:

1. Both forms are of the same table
2. The main form has two combo boxes and the data types are text. One
control source is named month and the other is named year.
3. Then I have the Subform within this form that is linked to customer name
, month and year.

My problem is when I switch back and for by months it's changing the data in
month. So if I'm in Jan and switch to Feb the Jan is now say Feb. Any idea
why?

Because you're asking it to do so.

If you have a combo box bound to a field in your table, and change the
value in the combo box, it changes the data in the table. That's what
it's DESIGNED to do!

What are you expecting to happen???

John W. Vinson[MVP]