Search Function

  • Thread starter Thread starter Nick
  • Start date Start date
N

Nick

I have a table with 2 fields, one is first name and one
is surname. There are around 4000 records in this table.
What i need is a property similar to Outlook e.g. when
you start typing the name it will bring up matches.

Any help would be greatly appreciated.

Nick
 
Try a combo with RowSource of:
SELECT Surname & ", " & [First Name], Surname, [First Name]
FROM MyTable ORDER BY Surname, [First Name];

Ideally, you would have a unique ID field as well, but the above 3 columns
should allow you to set the combo's Bound column to 2 (so it stores the
value into the Surname field), and use its AfterUpdate event to assign the
value of its Column(2) to the First Name field. (Remember Column() is
zero-based.)
 
Allen thanks very much that has worked a treat. Another
question if I may. In the same table i have got an email
address field for everyone. What i want to do is when the
name has been entered into the combo box and the new
record is saved an email will automatically be sent to
that person with a short message.

Thanks Nick
 
I am using that, the only problem is that the user then
has to click the send button on the actual email, what i
want is for the email to be sent without the user seeing
it.

Thanks

Nick
 
Nick said:
I am using that, the only problem is that the user then
has to click the send button on the actual email, what i
want is for the email to be sent without the user seeing
it.
Click to expand...

Check the help file for the second to last argument of SendObject
(editmessage).
 
Back
Top