My database has only two tables
Form 1 has three steps each with their own button, each button opens a new form.
Step 1 - Button 1, opens Form 2. Which has a button that runs an update query that resets 15 Yes/No fields in Table A to no. Closing Form 2 returns the user to Form 1
Step 2 - Button 2, opens Form 3. This form allows the user to add a new record to Table A. Closing Form 3 returns the user to Form 1
Step 3 - Button 3, opens Form 4. This form has one textbox and one button and does two things. When the button is clicked it ...
- It resets the values on the only field in Table B, based on the value entered into the textbox on Form 4.
- It then updates two Yes/No fields for all the records in Table A to yes with vba UPDATE code.
My problem:
If I add a new record in step two
The two fields in the new record are not updated in step three.
How do I get step three to requery Table A, so that the UPDATE code updates ALL the records?
I hope I explained it clear enough.
Thanks
RJW
Form 1 has three steps each with their own button, each button opens a new form.
Step 1 - Button 1, opens Form 2. Which has a button that runs an update query that resets 15 Yes/No fields in Table A to no. Closing Form 2 returns the user to Form 1
Step 2 - Button 2, opens Form 3. This form allows the user to add a new record to Table A. Closing Form 3 returns the user to Form 1
Step 3 - Button 3, opens Form 4. This form has one textbox and one button and does two things. When the button is clicked it ...
- It resets the values on the only field in Table B, based on the value entered into the textbox on Form 4.
- It then updates two Yes/No fields for all the records in Table A to yes with vba UPDATE code.
My problem:
If I add a new record in step two
The two fields in the new record are not updated in step three.
How do I get step three to requery Table A, so that the UPDATE code updates ALL the records?
I hope I explained it clear enough.
Thanks
RJW