Combobox not displaying results

[larpup]

I have a cbobox based on a query. It is bound to the correct column
(1). I populate it either by using it normally, or, I pop up a form
(from a cmd button) and return the results to the cbobox. When the
(pop-up) form closes, it writes the data to a field the main form and
does so perfectly. the cbobox control source is that field. Done this
too many times to count. Tab count in correct order.

I've used the debugger and can see the data is there (the ID# in the
cbobox).I've checked the underlying table and the record has been
written as it should be.

The problem is that when the pop-up form is utilized, the cbobox
appears empty (although the data is really there). the other fields,
tied the the cbobox are populated perfectly. I've tried refresh to no
avail.

Any ideas at all?

Lar

 

[John Vinson]

The problem is that when the pop-up form is utilized, the cbobox
appears empty (although the data is really there). the other fields,
tied the the cbobox are populated perfectly. I've tried refresh to no
avail.

Check the ColumnCount and ColumnWidths properties of the combo box,
and compare them with the RowSource query. Is the first column with a
nonzero width in fact the one you want displayed?

John W. Vinson[MVP]

 

[Guest]

Try creating a fresh cbobox. It's possible for a hidden SQL statement to end
up with the wrong contents if you changed the field names or sources.

 

[larpup]

Check the ColumnCount and ColumnWidths properties of the combo box,
and compare them with the RowSource query. Is the first column with a
nonzero width in fact the one you want displayed?

John W. Vinson[MVP]

John,

Everything is correct as you have questioned. I don't think the problem
is here.
One thing, the table being looked up has an alias so I can use one
table for Shippers and Consignees.

Any other ideas?

 

[larpup]

Check the ColumnCount and ColumnWidths properties of the combo box,
and compare them with the RowSource query. Is the first column with a
nonzero width in fact the one you want displayed?

John W. Vinson[MVP]

John,

Everything is correct as you have questioned. I don't think the problem
is here.
One thing, the table being looked up has an alias so I can use one
table for Shippers and Consignees.

Any other ideas?

Lar

 

[larpup]

Twas,

I did. checked everything John mentioned. Still no luck. As mentioned
in my reply to John, the table being looked up has an alias in the
relationships so I can use one table to lookup Shippers and Consignees.
I use the alias on another combobox and same happens. All fields tied
to each combobox work pefectly in both cases... Really lost on this
one. Just can't figure it out.

Lar

 

[larpup]

John,

As soon as I unload the form and reload it, the data appears.... Does
that shed any light on a solution?

Regards,

Lar

 

[larpup]

John,

I think the problem is not the combo box but the use of an alias table
linked to the master.

When I pop-up a form, enter in a new shipper and exit the form, the
data is entered into the combo box. I've tested with the debugger. The
data is also written to the underlying table.

The only way the data will display in the combobox is if the form is
unloaded and then reloaded.

I'm sure the tables are linked properly.. So i guess the issue is using
an alias table.

Any ideas here?

Regards,

Lar