Moving record from one form to another.

[P-C-Surgeon]

I have a form that lists the records of current jobs. Once I complete these jobs, I would like to move these records to another form (for example-complete jobs). What is the best way to accomplish this task? By the way, my current form does have a subform that also keeps data of the current record showing on this form.

 

[cstlaurent]

Personnaly I will rather add a flag that will indicate the Job is completed or not in the table. After it is easier to search and manipulate the date.

The other option is with an append query that will copy the selected into the new table.

insert into tbl_cplt select * from tbl_inprogresse where job_id = ....

 

[Norie]

P-C-Surgeon

You should add a field that indicates whether a job is completed or not.

Then you could add command buttons to filter the records to show completed, incomplete and all.

 

[P-C-Surgeon]

Applying multiple filters with command buttons

Thanks for the suggestions. I have figured out how to apply a single filter with one command button which shows the completed jobs, but is there a way to have the multiple command buttons for the current, completed, and all jobs. Anyway you can give me an example. Thanks for your time.

 

[Norie]

How have you done it with the one command button?

I'm sure you could use similar code to do the other command buttons.

I'm afraid I couldn't really post an example as the code would need to be specific to your particular setup/tables/forms/etc.

Perhaps you could post the code that you currently have.

 

[SydneyGeek]

You could also use a combo box with the list of possible Status codes, and have a Case statement in the AfterUpdate event which selects a filter to apply to the subform.
Uses less real estate than a bunch of buttons, and can be updated as your needs change.

Denis