Create a button on a form to open a certain record

[zashaikh]

I want to create a button on my single form called btnDELTA.

When btnDELTA is clicked, I want access to search through the field called txtStatus across ALL records for the word "replace". I want it to bring up the first instance were "replace" is listed in the txtStatus field.



I need this because I need to overwrite several records. I marked those I need to overwrite with txtStatus.Value = "replace". Instead of clicking an "add new record" button, I want to click a button that will take me to the earlist "replace" record.

[ranman256]

sub btnDELTA_click()
  Me.Filter = "[Status]='Replace'"
  Me.FilterOn = True
end sub

you can then turn the filter off , by click it off on the toolbar.