How to highlight an entire row of records and hold this format

[Marshall Barton]

Back two or three posts, I explained that "what it does is
select the entire record, the same as if you clicked on the
record selector".

I also emphasised that it must be in the **subform** Current
event, not in the main form.

You say that you see no effect from using the SelectRecord
method. That is different from what I see in my tests, so I
don't know what else I can tell you beyond my original
statement that datasheet forms are far more limited that
continuous forms.

I **think** Albert's code will accomplish the same thing
using different mechanisms. Since we can't seem to get
anything working, why not give it a try?

 

[postman]

Bingo!!
yep your right about that.
got it to work, It'll do nicely
Putting it in the subform did the trick, I originally put it in the form's
suby by clicking on the suby's box. So that why it not worky!!
Excellent stuff.
THANKS.

Back two or three posts, I explained that "what it does is
select the entire record, the same as if you clicked on the
record selector".

I also emphasised that it must be in the **subform** Current
event, not in the main form.

You say that you see no effect from using the SelectRecord
method. That is different from what I see in my tests, so I
don't know what else I can tell you beyond my original
statement that datasheet forms are far more limited that
continuous forms.

I **think** Albert's code will accomplish the same thing
using different mechanisms. Since we can't seem to get
anything working, why not give it a try?
--
Marsh
MVP [MS Access]

As I have already stated YES the line of code was put in...and as I have
already asked "what does it do"? as it appeared to do nothing.
For ref to that question go back 2/3 posts.
Again what does it do?

Can you see any application in the code from Albert D. Kallal:
me.RecordSet.FindFirst "id = " & me.OpenArgs
& also:
Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)

' key hand
On Error Resume Next

Select Case KeyCode

Case vbKeyUp
KeyCode = 0
DoCmd.GoToRecord acActiveDataObject, , acPrevious

Case vbKeyDown
KeyCode = 0
DoCmd.GoToRecord acActiveDataObject, , acNext

End Select

End Sub