Fill in the name

  • Thread starter Thread starter dk
  • Start date Start date
D

dk

I making simple clients correspondence database.
I have field ClientName. When user starts with the input, id like to offer
him names previously recorded ( as is in outlook -> new e-mail->to: when
auto complete is on).

Any suggestion where to start. I presume that I need to use activeX
controls, but... This is unknown area for me.

Thnx in advance for any help !

DK
 
No active X needed...

Design a form...
Make sure that the form Header is seen (VIEW...HEADER)
Make sure that the wizards is on....(looks like a lightning bolt on the
toolbar)
Click on the field you want (clientName) and then the comboBox tool

Draw a comboBox in the Header section. The wizard will pop up to walk you
through the steps,
one choice will be "look up a record on my form..." use that one.
After they have selected a previous name it will take them right to that
record.

If you simply want to keep track of all the names used so far (but not go to
the record)
then make a combo box with its recordsouce (...) that is a Select Distinct
[ClientName] from [WhateverTheTableIsCalled];

This will give a list of all the names entere thus far.

HTH
Mal.
 
Thnx Mal !
But I dont want to have button combo box have.
DK
Mal Reeve said:
No active X needed...

Design a form...
Make sure that the form Header is seen (VIEW...HEADER)
Make sure that the wizards is on....(looks like a lightning bolt on the
toolbar)
Click on the field you want (clientName) and then the comboBox tool

Draw a comboBox in the Header section. The wizard will pop up to walk you
through the steps,
one choice will be "look up a record on my form..." use that one.
After they have selected a previous name it will take them right to that
record.

If you simply want to keep track of all the names used so far (but not go to
the record)
then make a combo box with its recordsouce (...) that is a Select Distinct
[ClientName] from [WhateverTheTableIsCalled];

This will give a list of all the names entere thus far.

HTH
Mal.


dk said:
I making simple clients correspondence database.
I have field ClientName. When user starts with the input, id like to offer
him names previously recorded ( as is in outlook -> new e-mail->to: when
auto complete is on).

Any suggestion where to start. I presume that I need to use activeX
controls, but... This is unknown area for me.

Thnx in advance for any help !

DK
Click to expand...
Click to expand...
 
Back
Top