Need Help on search

[hamish]

Please can anyone help,I have attached sample database.I need to search for jobcard no.My main form is customer and one customer has many jobs i need to go to that job no,,,,,hope someone can help,,,i am new on this access...

 

[Tanya]

Here, its not pretty, but you should get the idea.

 

[hamish]

Thanks Tanya...It looks like what i want
Thanks again
hamish

 

[Tanya]

You are welcome, glad I could help.

 

[hamish]

Tanya If you look on top right i put a text box there,what i need to do is look for a jobcard no.I want to go directly to the jobcar no...You will see below payments there is a jobcard no,,,i need to search for a particular jobcard no in the subform...one client can have many jobcards..I hope you can help

I hope it makes sense..

 

[Tanya]

Sorry, too late to spend any more time on this and going away for a couple of days.

I am sure some on this forum will be able to help you.