Moving through records in a subform sheet

[gtaborda]

Hi there

I need to move through each record on a subform sheet.
I don't want to use

Set dbs = CurrentDb()
Set rst = dbs.OpenRecordset(sqlline)

Instead what I want is for the cursor to go focus on field1 of record 1, then field1 of record 2, field1 of record 3, etc

I need to physically set the focus on each line/record of the sheet.

Any ideas how to do this ????
thanks

 

[PHV]

Use the Recordset property of the Form object.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[TheAceMan1]

How are ya gtaborda . . .

A starting point:

[blue]   [[purple][b][i]subFormName[/i][/b][/purple]].Form.Recordset.MoveNext[/blue]

See Ya! . . . . . .

Be sure to see FAQ219-2884: