Access Query Subform Value

Hi,

I have a subform which is a query which will only return one record and I would like to know how to reference the values in this query subform?

Thanks
Mark
mcs26Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
INHOUSERESConnect With a Mentor Commented:
Dim db as Database
Set db = CurrentDB
Dim rstQ as Recordset

Set rstQ = db.openrecordset("qryQueryName",dbopensnapshot,dbseechanges)

'rstq(0) = first field
0
 
INHOUSERESCommented:
There's probably an easier method to grab the queryname from the subform, but both will get you the same results.
0
All Courses

From novice to tech pro — start learning today.