Dear All



I need that when enter data e.g. ID card no of any person in a field then control goes for searching either that ID card is present in the table or not. If presenet then display that record(s).

For Example.
Id Card no Name visit purpose visit date

Record1 123 asdf billing 23-02-2006
Record2 234 lkjh meeting 16-03-2006
Record3 123 asdf enquiry 20-03-2006

So as user enter ID card no for record4 as 123 the following window or subform report (whichever is suitable) will apper so that the user identify how many time that Id visited the office.

Record1 123 asdf billing 23-02-2006
Record3 123 asdf enquiry 20-03-2006

an early respose is required.

Thanx.

Wasim