Record search & open new form

[Geoffk]

Hi All

In my DB I have 2 tables "Customers" and "Job_Input"

The "Customers" table is updated daily and each customers is identified by a JobNo.

The "Customers" table is a contiuous form which displays todays customers, each customer has a command button ("Update").

The objectives are to:
1. Open form "Job_Input" and display customers details based on the JobNo.
2. Once details are entered into form "Job_Input" click on command button "Save" which will save data in "Job_Input" and delete record from "Customers" table

I have read through and tried many threads but still can not achieve my objectives.

Can anyone help with this.

Thanks in Advance
Geoffk

 

[ajetrumpet]

1. Open form "Job_Input" and display customers details based on the JobNo.

You can do this with a DoCmd.OpenForm command and writing a WHERE clause with it. The optional syntax items (like the "criteria" section) you can find in the help menu.

2. Once details are entered into form "Job_Input" click on command button "Save" which will save data in "Job_Input" and delete record from "Customers" table

I would think you could write a simple DoCmd.RunSQL command for this and specify the record to be deleted in a WHERE clause, using the "Customers" form's record as criteria.

 

[Geoffk]

ajetrumpet

Thank you for your reply, I have tried but still cannot get this to work.

I am not very experienced with code, could you please point me in the right direction

Thanks again
Geoffk

 

[Rabbie]

Do you never do a second job for the same customer? If you do then you need a customer table and a job table. Is your db normalised. If not read up on normalisation.
An un normalised db will make everything you do much harder.

 

[Geoffk]

Rabbie

Thanks for the reply

Each customer is an individual job and never duplicated

Geoffk