Not Able to Reference Row Source query after Column 1

[DefinitelyMaybe]

Hi All,



I have a row source query that has 4 fields: Project number, Project name, Project code and Business unit. Project number is the combo box with the query and works fine. Project description is a text box that references [Query].[Column](1) and also works, but Project code and Business unit are coming up blank when using [Query].[Column](2) and [Query].[Column](3). What am I doing wrong?

Thanks in advance,

Eric

[mike60smart]

Hi Eric

Can you upload a copy of the Db?

[Gicu]

You don't use the Query.Column syntax (queries don't have columns, they have fields) but your combo box control name; lets say you have cboProjectNumber as the combo, bound column is the first one so ProjectNumber is cboProjectNumber (no need to specify the column for the bound one or cboProjectNumber.Column(0)), ProjectName is cboProjectNumber.Column(1), ProjectCode is cboProjectNumber.Column(2)....

Cheers,

[DefinitelyMaybe]

Hi Mike/Vlad,

I still can't tell what I am doing is wrong... I wrote query but meant combo box. I attached the db as Mike suggested.

Thanks,

Eric

PS Glad to see you both active on the site. I have been away for awhile but you both helped me tremendously when I was here a year ago!

[mike60smart]

HI Eric

The Column Count on the Combobox was set as 1 - I changed it to 5

I have tidied the form up but the table needs a Primary Key - Autonumber

[DefinitelyMaybe]

Thanks Mike. I knew it was going to be something to bring in more columns since the description column did come in. I didn't think to look in the Format section. Good to know!

Cheers,

Eric

[DefinitelyMaybe]

Hi Mike,

Making that change did affect the dropdown for CS Proj No. Can I have the other 4 columns not show?

Thanks,

Eric

[ssanfu]

Along with the Column Count on the Combobox, I would set the Column Widths to 1.5";0";0";0";0"


A few other issues I see are:
----------------------------
Tbl_Make_Our_Projects does not have a Primary Key field (IMHO, I think every table should have a PK field)
Tbl_Make_Our_Projects.State/Province has a special character in the name (the "/")
Spaces in the field names of "Tbl_Make_Our_Projects"
"CS_Proj_No" is not set to be unique.

"ID" is a poor field name.....

[DefinitelyMaybe]

Thanks Steve! I appreciate the other comments as well.

Eric

[Gicu]

Hi Eric, welcome back, glad to see you solved it!

Cheers,