Delete Record

[Lynn_AccessUser]

I have a form which opens to a filtered record. Problem if the user deletes the record for some reason it goes to a new record. I created the delete button using the wizard and added a line to close the form.

 

[Mile-O]

I created the delete button using the wizard and added a line to close the form.

Would the code attached to that button look anything like:

DoMenuItem.

If so, delete the lines and replace them with:

DoCmd.RunCommand acCmdDeleteRecord

 

[Lynn_AccessUser]

Yea, I thought of that also and tried it but it still goes to a new record.

 

[Mile-O]

What method have you used to open the form filtered to a record?

 

[Lynn_AccessUser]

On the search form the user can choose the ReqID from a combo box. The combo box is called cboReqID.

On the load event of the form I have:

Me.Filter = "ReqID=" & Forms!frmSearch!cboReqID
Me.FilterOn = True

 

[Mile-O]

No idea, then, as I wouldn't (and haven't) use the FilterOn etc. properties. Rather than performing a filter on the form's load event I would do the filter on the calling form (the search form in your case)

i.e.

DoCmd.OpenForm "MyForm", , , "ReqID = " & CLng(Me.cboReqID)

 

[Lynn_AccessUser]

What is strange is that I am doing almost the same thing in another db using the same method of filtering to a specific record when the form loads and I am not having any issues.