Hi everyone,
I have a question concerned forms. On my form, I have a button that appends, a single, record to a new table (this was done for a special case, not normalized but organized). The button runs a macro that append a record to a new table, and deletes the record from the old table. Then, the macro opens the new form (associated with the new table) and closes the old form.
I would like to set this up so that the user can append a record, and have the form pop up to the record that was just appended. This is so that the user can add in new information that wasn't in the fields of a previous table. Any idea what SQL or VBA code I could use to make it do that? Any advise or information is greatly appreciated.
Thank you,
PPat