Button Find and Find Next in form/subform

[Natha2]

Hi,

We are a telco and have an Access project that manages the customers and their telephone number(s).

I have a main form with a subform in it.

The records in main form (customers) come from one table and are unique.

The records in subform (telephone numbers) come from another table.

A same telephone number can be owned by two or more customers (for different periods, of course).

I want to have a text box where user can input some telephone number, click on a button "Find" and the matching customer be displayed in the main form.

If the first find is not what he wants, he should click on (the same or) another button "Find Next", and the next matching customer be displayed in the main form.

And so on, till he gets a message like "No more matching records...".

What method could I use for that?

Thanx in advance for any help!

 

[PHV]

Have a look at the Filter and FilterOn properties of the Form object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[TheAceMan1]

How are ya Natha2 . . .

With the [blue]Filter[/blue] method (already addressed by [blue]PHV[/blue]), you'll get all matching numbers in one shot!

See Ya! . . . . . .