Copy and use the same Search text box command on one form to another form

[mcervenka1]

I created Form "Inquiry Record" containing a Text box search to search for a record and copied the Form and saved it as another Form named "Update Record". In additional I created embedded marco in the "Inquiry Form" to find a display only the record. I wrote similar coding using VBA that in addition to the search, also limits the display to the record searched for and all duplicate records and not the rest of the records in the table. Immediately after I enter the search requirement in the UPDATE RECORD form, I receive a parameter query popup screen requesting the search requirement that would normally be entered in the INQUIRY RECORD form. It is like the UPDATE RECORD is running two different set of instructions. Is it because I copied the INQUIRY SCREEN and all of it's coding and instructions and named it "UPDATE RECORS", that I am getting the paramenter query popup box from the INQUIRY RECORD on the UPDATE RECORD form?

[NeoPa]

You know I'm no expert in Macro work M, but it seems to me that the macro may be written to work specifically with the original Form.

If that's true, and I'd be reasonably confident it is, then you either need to create a new macro which is similar but refers to the new Form instead, or throw it away and do it using VBA.

Personally I'd advise the latter. There's no place in professional Access databases for the old macros (IMHO).