Highighting specific record in a sub-form

[Whit]

I have a sub-form populated by a table. I want to go to a specific record in the table and have it highlighted in the sub-form. I sequentially read the file in a loop until I get to the record I want. I know I have just read the desired record as I have a watch set showing me the record id. But in the sub-form, the first record in the table is highlighted, not the one I just read. What do I need to do to highlight the record that was just read? I did a subform.requery, but that didn't work.



Thanks

Whit

[Micron]

is this a continuous form? If yes, easier to point you here https://answers.microsoft.com/en-us/...9-e068debcab84

See the Marshall post.

You could also try conditional formatting on all of the record fields, which someone may elaborate on here, but you might have a lot of fields in a row.

[Whit]

No. It is not a continuous form.
I just assumed that whatever was the current record based on the code reading the table would be highlighted just as if the user had clicked on that record.

[Micron]

Then I guess it's a datasheet view. I guess I should have been very explicit about what I wanted to know, or at least should have covered all the bases.
Then it seems you'll want to use conditional formatting for all the controls in your detail section. Since you are able to ascertain the record id, you should be able to have the added textbox (per the link I provided) be updated via code to be either of 2 values (e.g. 1 for being the selected record, 0 for not) and the cf condition being that the background is a different color when the condition is 1.

Also more example(s) here and other Google results (starting with post 6)
https://www.access-programmers.co.uk...d.php?t=294753

[Missinglinq]

...I sequentially read the file in a loop until I get to the record I want. I know I have just read the desired record as I have a watch set showing me the record id...

Not sure exactly what you mean by the above, in red, but if you mean that the desired Record is the Current Record, you might try, after the line that 'finds' the desired Record

RunCommand acCmdSelectRecord

Linq ;0)>