Re: Setting combobox rowsource

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Access does not load the RowSource of the combo for every line, i.e. only
the items in the current record can be displayed.

That limitation only applies if the combo's bound column is zero-width. If
it can display the actual bound value, then there is no problem with the
display on the other rows.

The other (messier) alternative is to make a query as the RecordSource of
the form, and include the table of countries/cities so you can place a text
box for the city on the form as well. Place it in front of the combo, and
make its width about 0.2" less, so the combo's drop-down can still be seen
and the user can't really notice it's a text box as well. Set the text box's
TabStop to No. In its Enter event, SetFocus to the combo. Now the combo
jumps in front on the current record only so the user can enter a value, and
all other rows show the text box in front.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Roy Goldhammer" <roygoldh@xxxxxxxxxxx> wrote in message
news:eX3G%23QqcFHA.3712@xxxxxxxxxxxxxxxxxxxxxxx
> Hello there
>
> I have Continues form with two comboboxes.
>
> The first Combobox rowsource is list of Countries on the world and the
> second combobox rowsource is the list of cities on the world.
>
> If the County combobox is selected i need to see only the citys in the
> parent country.
>
> It works fine on the current record. But if in one of the other records
> does not contain the same country. I can't see the city i've chosed,
> because the row source is efected on the entire form.
>
> Is there a way to show the other citys on another records that not
> selected?
>
> any help would be useful


.

Relevant Pages

  • Re: Bibliographies in Word 2007
    ... I have been using your BibWord and succeded to prepare a custom style: ...   Title. ... City: Publisher, Year. ... but if you want something simple to display like ...
    (microsoft.public.word.vba.general)
  • Bloomington bans Bible, but welcomes Buddha
    ... Buddha is welcome but the Bible is banned at the Bloomington, Ind., city hall after officials booted a display of the Ten Commandments erected by Christians wanting equal treatment with the Far East religion promoted by the Dalai Lama. ...
    (soc.retirement)
  • Re: Combo Box List
    ... You do this in the rowsource, column count and column width properties. ... to display the ID field so you would set its width to 0. ... the bound column is displayed. ... Your Resource For Help With Access, Excel And Word Applications ...
    (microsoft.public.access.formscoding)
  • Re: Cascading Combo Boxes (Multiple boxes)
    ... No, becuase every combo will have a list to display, but not filtered. ... have lists to display. ... You now have 4 combo boxes. ... If you select a value for C2 then C3 and only C3's rowsource needs to be ...
    (microsoft.public.access.forms)
  • Re: Combobox on Coninuous form.
    ... combobox usually has an ID field and a value field in its rowsource, ... form needs a hidden textbox to hold the ID field and the textbox you mention ... > display an unbound column. ... > the form's record source query needs to be modified to ...
    (microsoft.public.access.formscoding)