Need to creat a job history

[RyDan46]

Iv creating a customer database and ive created a forum with the customers info, but at the bottom of each customers page i would like a list box where u can click on a date and it will come up with enough form, with info on the job done at that date.

Has anyone got any advice on how i can do his

many thanks in advace

RyDan

 

[Remou]

Hi
How about something like this:

DoCmd.OpenForm "NewForm", , , "CustomerNo = " _
    & Me!CustomerNo & " And Date=#" & Me!ListBox & "#"

It takes advantage of the Where property of the OpenForm method.

You might prefer to use a subform on your Customer form, listing all jobs?