Updating one form from another form

[henley12]

I have a form that performs a DLookup to populate fields on the form based on an Equipment ID. I also have a "search" button next to the Equipment ID field that pulls up the Equipment form to verify or edit that record. If I make a change to the record on the Equipment form, it should update the main form upon closing the Equipment form. I can do a requery of the main form, but it takes me back to the first record. Any ideas?

 

[TheAceMan1]

How are ya henley12 . . .

In the [blue]Close[/blue] event of the equipment form:

[blue]   Dim frm As Form, hldID As Long
   
   Set frm = Forms![purple][b][i]MainformName[/i][/b][/purple]
   hldID = EquipmentID
   frm.Requery
   frm.Recordset.FindFirst "[EquipmentID] = " & ID[/blue]

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[TheAceMan1]

woops! . . .

Should be:

[blue]   Dim frm As Form, hldID As Long
   
   Set frm = Forms!MainformName
   hldID = EquipmentID
   frm.Requery
   frm.Recordset.FindFirst "[EquipmentID] = " & [b]hldID[/b][/blue]

See Ya! . . . . . .

Be sure to see FAQ219-2884: