Return Addresses based on Characters entered 1

[HawkWeb]

Hi
I have a table field containing all possible locations in a County. tblLocation

As user enters characters in Forms Location field frmLocation
I need to display all matching tblLocation fields based on characters entered EG (Results displayed in Pop-Up Form)

frmLocation = T Returns

Talbot Green
Tallest Lane
Teen Street
Timber Grove

frmLocation = Ta Returns

Talbot Green
Tallest Lane

frm Location =Talbot Returns
Talbot Hotel

Using Access 2000

Can anybody provide me with code to achieve above

Thanks
H

 

[PHV]

Why not using a ComboBox with the AutoExpand property set ?

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

 

[HawkWeb]

Thanks PH

Will Experiment and get back

H

 

[HawkWeb]

PH

Another word of thanks.

Better option then I had suggested.

Works brilliantly

Very Pleased

Regards

H