[AccessD] Finding a record in a subform

Andy Lacey andy at minstersystems.co.uk
Mon Jul 18 09:30:01 CDT 2005


Hi John
When you say find a record in the subform are we talking about positioing
the user there? If so how about something along the lines of (not tested):

Dim rst as Recordset

set rst=Me!subThingy.Form.RecordsetClone

rst.FindFirst etc

If Not rst.NoMatch Then
Me!subThingy.Form.Bookmark=rst.Bookmark
End If

rst.Close
Set rst=Nothing

--
Andy Lacey
http://www.minstersystems.co.uk




--------- Original Message --------
From: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
To: "accessD at databaseadvisors.com" <accessD at databaseadvisors.com>
Subject: [AccessD] Finding a record in a subform
Date: 18/07/05 11:34


Hi all
This must so easy but my brains are not in gear. I have a form with a
subform (both in form view) and with one-to-many relationship. How do I find
a
particular record in the subform in?

TIA

johnc
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

________________________________________________
Message sent using UebiMiau 2.7.2




More information about the AccessD mailing list