Weird cbo behavior on subforms

[Lythandra]

Hi there,

I have some weird cbo behavior on subforms on Access 2000.

What is happening is that I have 2 cbos (unbound) that act as criteria for
the subform once the selections are made in them.

If there is no data for the criteria selected then the subforms will not
show the selections made in the cbos making it appear as if they are empty.
However the values are in the cbos.

Now if there is data to display, then the data comes up fine for the subform
and the cbos at the top will now display the values.

It is just confusing for users as they think they have not picked the
criteria in the cbos when there is no data to display.

Anyone else had this happen and know of a fix?

Remember, these are unbound cbos just being used to select data to use as
criteria for the subforms query. I know of no reason why they should appear
blank even tho they do indeed have the values selected in them.

 

[Allen Browne]

If:
a) a form has no records to display, and
b) no new record can be added,
then the form's Detail section goes completely blank,
and the combos (presumably in the Form Header section) do not display
correctly.

More info in:
Incorrect display of data
at:
http://allenbrowne.com/bug-06.html

 

[Lythandra]

Thanks Allen,

I thought it was a bug but its nice to get confirmation.

I appreciate the help you do on here.

 

[Lythandra]

As a side note Allen,

It seems that the text boxes made to receive the missing field do not like
the normal background setting 100% of the time.

So far, when I set the background to transparent (on the text boxes), they
seem to display the missing cbo info every time, after an additional step.

I am doing mine slightly different than than your page said tho.

After update of the cbo, I am then assigning the value to the text box in
code (no tab and locked) and then I am also doing a docmd.gotocontrol
("BackupProjectID") which then will finally cause it to display the data. I
am doing the same with my second cbo also.

I am also shortening the cbo to just show the drop down part on the right
and putting the text box next to it so that it appears to be a normal cbo to
the user.

So far, it seems to be working correctly to display. *crosses fingers*

 

[Lythandra]

For a text box being used as a search string as criteria for a subform,
turning the background transparent and then doing a gotocontrol to itself
after update is also making it show up again for when there is no data to
display.

yay, no more confused users!!!!