Open filtered for and set cursor at particular record

[Moss100]

Hello,

I have a form which shows repairs for properties.

I currently open the form from a button and filter results to a particular property using the code below - which works fine.

DoCmd.OpenForm "frm_Repair", WhereCondition:="[Prop_ID]= " & Me.Prop_ID

The repairs also have a primary key [Repair_ID]

I would also like the cursor to go to the Repair number which is stored in the textbox txtRepair_ID on the form I use to launch frm_repair

Could someone help with this?

Many thanks
Mark

 

[Moss100]

I solved it by adding:

Forms("frm_Repair").Form.Recordset.FindFirst "[Repair_ID] = " & _
Forms("frm_Landlord_Properties_Repair").[txt_Repair_ID] & ""