Combo box doesn't show data

[Apollo13a]

Hi, I have a subform linked to a combo box on my main form. I changed one of the text boxes in the subform(the name of the box is UnionNumber) to a combo box and now it doesn't show any data. The rest of the subform show all correct data. I set the record source in the combo on the subform and when I check the record source for the subform the correct data is displayed. How do I get the combo to display the same data as in the record source query? Here's my record source:

SELECT tblHours.tblHours_ID, tblHours.ST, tblHours.OT, tblHours.DT, tblHours.Shift, tblHours.WorkDate, tblHours.Jobs_ID, tblHours.ContractorID, tblUnion.UnionNumber
FROM tblUnion INNER JOIN (tblJobs INNER JOIN tblHours ON tblJobs.tblJobs_ID = tblHours.Jobs_ID) ON tblUnion.tblUnionID = tblJobs.JobLocal
ORDER BY tblHours.WorkDate DESC;

Thanks, Jim

 

[JBinQLD]

G'day Jim,

Have you set the column count property of the combo to 9 (As your query returns 9 pieces of data)?

These values must tally up, and you use the bound column to say which the combo actually stores., in your case, probably 1 as it's the ID field.

You then use column width property to hide the columns you don't want. Eg.

0;0.5;0.5;0.5;0.7;1;0;0;0

would just show you ST, OT, DT, Shift and date...

Good luck,

JB

 

[Apollo13a]

Hey JB, yes I set the column count property and the column widths property to 9 as you suggested. My subform combo still doesn't show a value. I also have a little vb code that refreshes everything after a selection is made in the combo on the main form.
thanks Jim

 

[missinglinq]

You don't say what version of Access you're running, but if it's 2003, this may apply.

Access 2003 that's been updated with the SP3 service pack is buggier than the Great Dismal Swamp! One of the most common bug reported involves comboboxes with disappearing data! The field(s) in the cbo, in the underlying table, have some kind of formatting in place. This is often the simple > used to force UpperCase. Remove any formatting from the fields and things should work short term, but the definitive solution is to install the hotfix for SP3.

Here's a link to Allen Browne's site where you can find the latest news about these bugs, as well a link to the Hotfix:

http://allenbrowne.com/bug-Access2003SP3.html

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!