Scroll menu when argument

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, My english is not that well but I will ty to explain. When an argument
is given in a form f.e. [client] than after clicking on the switchboard you
are directed to a selection area to put in the client name before you can
open the report. It is sometimes hard to know the exact name of the client.
Even a small mistake like a capitol can give you no results. So it would be
much easier to have a scroll down menu to choose from so that you always have
the right spelling, and result after.
I think that must be possible but I can not find how. Can someone help me
with this. Thanks
 
The "selection area" is a form?? If so, then put a combo box with the
client names as the row source in the properties for the combobox. You may
have to create a sql statement for this using the client table as the
source.
Then you should be able to enter a few characters of the client's name and
the combobox will display the match.
 
Hi, What I mean is the popup box before opening a form when an argument is
needed. Example the argument in the form is Between[dat] And [date]
When you open the form first it wil ask to give in the start dat and the end
date in that box so that you get only the data in between those two dat. So
I made this so to look for oders by clients. So I will have to give in a
client name to get the results for that client. It would be good to have
some kinda scroll or suggestion of what is in the database so that I can not
mispell the name. I hope you understand what I am saying.

Damon Heron said:
The "selection area" is a form?? If so, then put a combo box with the
client names as the row source in the properties for the combobox. You may
have to create a sql statement for this using the client table as the
source.
Then you should be able to enter a few characters of the client's name and
the combobox will display the match.

--
Damon Heron

George said:
Hi, My english is not that well but I will ty to explain. When an
argument
is given in a form f.e. [client] than after clicking on the switchboard
you
are directed to a selection area to put in the client name before you can
open the report. It is sometimes hard to know the exact name of the
client.
Even a small mistake like a capitol can give you no results. So it would
be
much easier to have a scroll down menu to choose from so that you always
have
the right spelling, and result after.
I think that must be possible but I can not find how. Can someone help me
with this. Thanks
Click to expand...
Click to expand...
 
Back
Top