(looks like) simple acces question: search in a form

[Dinictus]

Hi,

I have a very basis data structure with name, adress and phone number.
Now, I want a form in which I can type the first letters of a name and then acces must automatically give the rest of the record.

so if I type "Di"

Acces already gives Dinictus, Rotterdam, 010-5763663.

It must be simple but I cant figure it out!
The stupid thing is, I built this in excell and it works fine but acces must be way better fot this kinds of things isn'y it?

Can anyone point me in the right direction?
Thanks al lot again.

 

[ChrisUK]

It can be done using a little VB code in the change event of your input field. The way to do it would be to count the number of records returned after each change to the input field.

I've had a go and got this working

Private Sub txtInput_Change()

x = DCount("FirstName", "NameSearch", "firstName like '" & txtInput.Text & "*'")
If x = 1 Then
rtn = DLookup("FirstName", "NameSearch", "FirstName like '" & txtInput.Text & "*'")
txtName.SetFocus
txtName.Text = rtn
End If

End Sub

You will have to tinker with the code a little to catch duplicate names or ones which are similar but you should get the drift.

If you have a name like Ben and also Benny typing Ben will not work as it sees Ben and Benny so the return count is >1.

Needs a little more thought but hope this help you on the way

Chris

 

[bat17]

you could use a combo box to make the name selection and use its afterupdate event to run the filter code for the rest of your data.

Peter

 

[ChrisUK]

I'm not sure I follow you ....

The Op said he wanted to type the first parts of the word and let the DB fill in the rest - i assumed when the first part of the word was unique.

How would a combo box help with this ?

 

[bat17]

A combo box by default will autocomplete the word as you type it in. soon as you have your word hit enter and you have what you want.

Peter

 

[ChrisUK]

Nice one, I didn't realise that!