Copying Info in macro (1 Viewer)

[rwpetrie]

How can I set a command button in a form to save the current information, go to add a new record, while saving some of the information just added?

For example, the person enters a Job number, then proceeds to enter items into a purchase order. When they are done with this PO, I'd like them to click a command button that will save the PO, while opening up another entry form that already has the Job number and header information there so that it doesn't need retyped.

How can I do this?

 

[BarkerD]

It sounds like you need to normalize the structure of your application.

If you have information that is duplicated in records in the same table, or in different tables, this is a good indication that it is a separate data entity.

Duane Barker