ms access datasheet select a specif record

[bambo]

1. I need to jump N reocrds down/up in an ms access datasheet.

2. I'd like to mark the current record in my datasheet by highlighting the whole row, and not just a single field in the record (similar to what's happen when the user presses the record selector)

any ideas?

[bambo]

I got 1. solved (recordset.move)

anyone about highlighting the whole row?

[bambo]

anyone?

[bambo]

someone?

[angie057]

Hello,

2. I'd like to mark the current record in my datasheet by highlighting the whole row, and not just a single field in the record (similar to what's happen when the user presses the record selector)

any ideas?[/QUOTE]


I would also really like to know how to mark the current record by highlighting the whole row! Anyone?

[incidentals]

you select the row using

rows(row:row).select
e.g
rows("5:5").select

Selection.Interior.Color = RGB(255, 255, 0)
or
Selection.Interior.Color = vbyellow
or
Selection.Interior.Colorindex = 24

you will need to know the red green blue mix the vbnamed color range or the color index values for your choices