ShowAll - combobox and row source

A

Ayelet

Good Morning Everyone :)
I have an interesting problem:
I have several subforms, each has a "ShowAll" button,
which determines if the combo box on the form show all the
records in the table (ShowAll = True) or just a part of
them using a certain criteria (ShowAll = False).
The problem is that, when I open the form with a record
that has records that are not in the smaller group, it
does not display them (the cmbbox is displayed as empty
instead) until I press the ShowAll button,which is ok- but
then it still doesn't show them, until i click
every "empty" combo-box to display it's contents. It also
presentes the data if I move to another record (on the
main form) and then come back.
My question is: Is there any way to prevent this problem,
display the item's names even if they're not in the row
source (the cmbbox's Bound column is an ID field, and it's
width is set to 0), or at least to identify the situation,
so i could at least do the switch-records thing
automatically, which is less efficient but somehow works.
TIA,
Ayelet
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top