Copy record into pop-up form

[arothacker]

I have a form that allows the user to select a drop down in one of the fields. If the user selects the value "Copy" from the drop down, is there a way to copy the record's information into a new form that pops up once the drop down is selected?

The pop up would be a new record, just with the same information. The user will then be able to edit a few fields in the pop up form.

Trying to figure the easiest way to go about this. Thanks!

[ItsMe]

This sounds like duplication of data. You could do it by creating a recordset clone of the first form via DAO and then updating/appending the new records in another table.

Why not just store the relevant key fields in your new records? Primary Keys and Foreign Keys are what make a relational database work. Duplication of data is an indication of a Non-Normalized database.

[arothacker]

Let me try to explain it a bit more. The database is for tracking headcount at a company. The form has Employee ID, Operating Company, Location, Employee Type, and Supervisor. Say Employee X (ID: 123, Op Comp: A, Loc: TX, Emp Type: Salary) left the company. There is a drop down field in the form for each record...so for this employee the user in the database will choose "Open" from the drop down. This prompts another form to pop up to enter a new record.

I want to be able to copy Employee X's ID, Operating Company, and Location into the new record since this position is now open. This will just prevent the user from having to type in all the information from Employee X. Does that make sense?

[ItsMe]

Post # 2 still applies.

[arothacker]

Okay I'll look into using recordset. Also when you say to store the relevant fields in your new record, what do you mean by this? We do have an autonumber primary key that I was trying to figure out how to utilize.

[ItsMe]

As for using DAO

Do some searches here on
OpenRecordset
RecordsetClone

Primary Keys and Foreign Keys are another subject and really are the basis for a Relational Database Managemnt System (RDBMS). You can do some searches on those terms and also Normalization.

Search You Tube and then maybe google
RDBMS normalization primary foreign