getting date from a subform

[jonny dexter]

i need to put a button on a tabcontrol which holds a subform.
when this button is clicked i would like it to return a value from the currently selected record in the subform (datasheet view)



How do i reference the selected record data ?

the column on the subform i need the data from is called date.

as the subform is on the current tabctrl page i was trying

Me.[Date].value and Me!subjuly.Date.Value

but i am getting an error back.

also could someone clarify the difference between the following

Me.subjuly and Me!subjuly ?

and why we would use

Me!subjuly.Form - does difference does the .form on the end make?

Is there anyway to get the IDE to show the values of these types of references whilst hovering over them ?

thanks in advance

[Access_Blaster]

Allen Browne answers the Me. or Me! question here Bang vs Dot

[NTC]

if the subform is displaying single records then the syntax is:
Me.SubformName.Form!TextBoxName

Form is literal

but if the subform is continuous mode showing lots of records this can't work because there are multiple records with the same control name.

[jonny dexter]

thanks for the links and help, i have read them through and hopefully some of it sunk in!

om sure ill be back shortly with afew more questions as i have a couple of issues at the moment but i like to try a few things before posting.

thanks again.