docmd.FindRecord on a sub form

[MartinF]

Hi,

I cannot seem to get docmd.findrecord to work on a sub form.
On my main form users can enter a record id in a text field, which then looks the record up on the sub form. The recordset for the subform is based on another field on the main form so that only records for the selected week are shown within the sub form. However i do not want to requery the sub form so that it only shows the required record, i need to keep them all showing, but have the specified one selected.

Any ideas,

Thanks in advance

MartinF

 

[DougP]

you need a "book mark"

Dim SyncCriteria As String
Dim f As Form, rs As Recordset

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

' define the criteria used for the sync
SyncCriteria = "[your keyfield]=" & Me![your textbox]

' find the corresponding record in the Parts table
rs.FindFirst SyncCriteria
f.Bookmark = rs.Bookmark
---------------------------------------

also to use this in Access 2000
open VBA program and click on the "Tools" menu then "References"
then find "Microsft DAO 3.5 Object Library"
put a check in it.
then click OK
DougP, MCP

Visit my WEB site

http://www.barcodeone.com

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

 

[MartinF]

Excellent!, thank you DougP, this works perfect.

Regards,

MartinF