Datasheet Search from another Form

[bobbye_69]

:banghead:
I have a form that shows details of a record. I have a command button to open associated records in another form in DS view. My code will open the DS and show all records or filtered to specific record.
What I would like to do is use code on command button to open DS view and simply highlight (find) the record that was being viewed in the first form.
Main Form = frmBroachBase
DS Form = frmBroachBaseDS
Associated fields on both forms are - [AutoID], [BroachID] - that can be used to link the two forms.

Any help on this is greatly appreciated.

 

[JHB]

Look at the feature "Conditional formatting".
Else post your database with some sample data, zip it.