combo box - all values blank

[jpatrick]

I've uploaded the db, could someone please help me figure out why cboAE on the 'other search' form displays a list of blank values?

I know it's gotta be something super simple but I can't figure it out and nothing I find online or on this site helps. I have plenty of other combo boxes set up exactly the same way (except I must be wrong because it's clearly not working).

Thanks!

 

[sneuberg]

I don't see a cboAE on the 'other search' form. I see a Combo4 on the Seach Other form, but without the linked files it's hard to tell what might be wrong. Please upload the backend database which has the tblBlocks, tblHotel Checks,and tblRoom Types tables.

 

[sneuberg]

Actually I can't find cboAE on any form. Did you unload the right database?

 

[jpatrick]

I'm so sorry, forgot to change the name of the combobox before I uploaded it but, yes, it is the only one on that form. I've corrected that and uploaded again along with the be. Thanks!

 

[moke123]

you have column count and column widths wrong. count should be 1 and width should also be set to what you want.

you should also probably have a seperate table for Acct. Execs.

 

[sneuberg]

You have the column count set to 2 and the widths set to 0";1" but the row source only has one column. Suggest trying a Column Count of 1 and Column Width of let's say about 2"

 

[jpatrick]

you have column count and column widths wrong. count should be 1 and width should also be set to what you want.

you should also probably have a seperate table for Acct. Execs.

Thank you!:banghead:

 

[jpatrick]

You have the column count set to 2 and the widths set to 0";1" but the row source only has one column. Suggest trying a Column Count of 1 and Column Width of let's say about 2"

Thank you!