If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Subform in a form
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? |
#2
|
|||
|
|||
Subform in a form
On Wed, 25 Oct 2006 14:34:02 -0700, PJ
wrote: 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] |
Thread Tools | |
Display Modes | |
|
|