Re: List Box

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Dan,
Thanks. I have been working on the combo and agree with you. I can now get
it to show the "Select Card" but now when the user selects the proper card I
use that for a field. Now when I call up the same record and the card is
selected like Visa I do not want the combo box to show "Select Card" again
but stay with the previous selection. Maybe I should use a different field
for the selected card or else some IF logic. I need room on the form as it
is crowed and would like to just use the Combo for the field. Any ideas??
Tony

"Dan Freeman" <spam@xxxxxxxxxxxxx> wrote in message
news:ejXBvPZyHHA.3916@xxxxxxxxxxxxxxxxxxxxxxx
Combo boxes are complex beasties and your answers will vary based on
whether your combo is bound or not and what rowsource you're using. (Not
surprisingly, arrays will work differently than tables. <g>)

The *simplest* way to get what you want is probably with an array and make
the first item "Select Card" in the array. Set the combo's .Value to 1 and
it will display the first item in the array when it starts up.

You might want to fiddle with the combobox builder (right click the combo
and choose builder) to get a feel for the various options.

Dan


TonySper wrote:
I worked out a Combo Box but how do I get it to display "Select Card"
when the form opens and then when user selects which card to use it
displays that card?? I can get it to display the proper card but
can't find a way to always display "Select Card" each time the form
opens. TonySper

"TonySper" <tsperduti@xxxxxxxxxxxxxxxxxxx> wrote in message
news:uY3zAkYyHHA.4260@xxxxxxxxxxxxxxxxxxxxxxx
I have never done this and it may be simple but I have been trying
all day to have a list box open, have user select from one of four
items in the list box and then have it close with the selected item
in a field. I see this all the time when selecting a charge card.
There is a field with an arrow to the right. The user clicks on the
arrow, a pop up list appears and the user selects which charge card
and then the pop up closes and the selected item is in the field.
Can anyone show me the way??? TonySper




.

Relevant Pages

  • Re: Problem with VBA Code behind form
    ... >> through which you can see the report. ... graphics card. ... the query calls from the table details of all ... >> selection is limited further by only choosing the records checked on ...
    (microsoft.public.access.forms)
  • Re: Random numbers with no duplicates
    ... Here are the relevant parts from a card dealer class: ... This selection process will proceed from ... Swap the selected location with the randomly selected location. ... Repeat the above process until you have done n swaps. ...
    (alt.comp.lang.learn.c-cpp)
  • Re: Random numbers with no duplicates
    ... The last card would always be swapped with itself, ... >> array once for any number of repeat uses. ... places the selected value outside the selectable range for the next ... selection. ...
    (alt.comp.lang.learn.c-cpp)
  • Re: Query Advise please
    ... Create a new query. ... print on the labels. ... where your data is stored as your selection ... > contacts that have "YES" in the Card Field. ...
    (microsoft.public.access.gettingstarted)
  • Re: Exporting/printing groups
    ... and I did have the right click copy selection. ... I get the little card icons next to the ... > Whether I highlight one or all of them, I don't get a "copy" choice ... The memo prints the name of the group and the ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)