Position on subform

[seeker63a]

I have a subform which holds data in a datasheet mode. when i delete a record i close the parent form and then reopen it because i am not having luck making the requery work. the user wants the position to be at the location the form was before deletion although it will be a different record. I have tried

DoCmd.GoToRecord acdataform, "frmVendorList", acgoto, 17 and it gives me a error saying that the frmVendorList is not open. That is the form that is the subform the line before i open the parent form. The name for the subform in the property sheet is frmVendorList. Thank you for your wisdom.

 

[GohDiamond]

Subforms should be linked to the Parent form with Master/Child links, then you can delete records without having to close the Parent form.
Also addressing a subform is done like this:
http://access.mvps.org/access/forms/frm0031.htm

Cheers!
Goh

 

[seeker63a]

Thank you for the response. the parent form has a textbox which when onleave a search is done on the subform to find the certain record. No master/child link needed. so when I search and find two records with BFI I delete one and then the form should appear with record selector next to the additional BFI entry.

 

[GohDiamond]

Set your focus on the subform then execute the command
Me.frmVendorList.SetFocus
DoCmd.GoToRecord acActiveDataObject, , acGoTo, 17

acActiveDataObject does not need a name

Goh

 

[seeker63a]

Thank you very much. I will do extensive testng tomorrow but initially it looks like this did the trick.