Sub requery + other question

[Ticotion]

Hi

I have a form containing two subforms (sub1 & sub2)

on sub 1 I have a combobox and a textbox and a unbound botton that saves the
information from the combobox and the text box. On sub2 I have a form showing
the informations that where input in sub1. My question is:

1. How do you requery sub2 after the sub1 button has been pressed?

2. How do I "blank out" the fields on sub1 so that the user has an "empty
combobox and textbox after the poerson has pressed the button?

Thank you for all your help

Ticotion

 

[Jeff Boyce]

A bit more information first, please...

Do you have:

Main form
Subform1
Subform2

or

Main form
Subform1
Subform2

and how are the subforms related (parent/child) to the main form and/or each
other?

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.