If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Problem with Edit form--please help
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 |
Thread Tools | |
Display Modes | |
|
|