Search form

[allie357]

I am fixing a previously created database created by someone else. In
their original db, there were not normalized tables, and this edit from

searched one table. Now I have a new edit form with the violator's
name in a combo box and many other combo and text boxes throughout. I
would like to have a button open a search and replace box like the
original but right now it is telling me that it is linked to other
tables so I cannot change the record. Thanks in advance for any help...


In the original form it was all text boxes and when you pressed the
find record button it opened a search and replace box with this macro
below.


Option Compare Database


'------------------------------------------------------------
' Edit_Violation_Goes_to_last_record
'
'------------------------------------------------------------
Function Edit_Violation_Goes_to_last_record()
On Error GoTo Edit_Violation_Goes_to_last_record_Err


DoCmd.GoToRecord acForm, "Violations_Edit", acNewRec


Edit_Violation_Goes_to_last_record_Exit:
Exit Function


Edit_Violation_Goes_to_last_record_Err:
MsgBox Error$
Resume Edit_Violation_Goes_to_last_record_Exit


End Function