Simple Commands

[Melissa]

Hello,

1. How do I determine the number of records in a query I
perform in a textbox on one form that has a subform (the
subform is the form i want the # of records)

2. How do I make a command button to click on a button to
open a new form that sends variables over. Ie: click on a
record and it opens a new form that gives all the details.

Thanks in advance,

Melissa

[Dean]

Melissa,

1. How do I determine the number of records in a query I
perform in a textbox on one form that has a subform (the
subform is the form i want the # of records)

>> use me.recordsetclone.recordcount

2. How do I make a command button to click on a button to
open a new form that sends variables over. Ie: click on a
record and it opens a new form that gives all the details.

>> in the onclick event of the after the docmd.openform

command you can assign values to text fields on the newly
opened form.
Example:
Docmd.OpenForm "myForm"
Forms!myForm!myText1 = me.Text1 'Where me if the
current form

- - -Dean