Showing dates on a new form

[RichieP]

When two dates are selected and the gender button is pressed, it brings back a form based on the query (I.e. the number of records between the two dates given by gender). All I need is the two dates that appear in the unbound text boxes (ealiest and latest dates) to appear somewhere on the form that comes up after the gender button is pressed (the form is called: Extraform_Date of determination between two dates GENDER.)

Any help given is appreciated!


Have a look . . . . .
NOTE: It's access 97'

 

[FoFa]

You could use dmin and dmax on the query to return the dates.

 

[Mile-O]

Put this on your Form's Load event:

Private Sub Form_Load()
    Label12.Caption = "By gender between entered " & Forms!Frmmain!txtDate1 & " And " & Forms!Frmmain!txtDate2
End Sub

The form you have called: Extraform_Date of determination between two dates GENDER.

 

[ghudson]

Try this...

 

[RichieP]

Cheers guys, just what I was looking for!