Goto Record

[zorro19s]

Lets say I want to go to show(highlight or point) record number 5 in a subform, how would I do that?

 

[KarMac21]

Depends what type of object your talking about - list box, combo box, or just record #5 in your recordset.

 

[zorro19s]

I have a table and on another subform just field list textboxes.

In the table, I would like it to point to the recordset or highlight the recordset.

In the field list textboxes I would like simply to go to a specific record.

 

[DougP]

Me![your subform].SetFocus

Dim SyncCriteria As String
Dim rs As DAO.Recordset

'Define the from object and recordset object for the form
Set rs = Me![your subform].Form.RecordsetClone

' define the criteria used for the sync
SyncCriteria = "[yourKeyfield]= " & Somevalue

' find the corresponding record in the Parts table
rs.FindFirst SyncCriteria
Me![Contacts subform].Form.Bookmark = rs.Bookmark
---------------------
This code requires you to know the unique ID of record number 5. Then it sets a bookmark to it and sets focus to it.
Suppose you have Contacts in the subform then you would have to know the ContactID of record number 5
DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive