Data not displaying

[wcboyd]

Hello All,

I recently added a couple cascading combo boxes to one of my forms and now the data from the underlying table that has already been entered does not show up unless I go in and reselect the options.

Anyone have any ideas on how to fix this?

Thanks,

 

[FoFa]

Sounds like your BOUND column in your combo boxes does not match the values on the underlying table, hence the need to reselect.

 

[wcboyd]

My BOUND property is set to 1

Here is some further detail that may help:
ComboBox1 = Project Type
In the "AfterUpdate" event I have the following code:
On Error Resume Next
ParentProjectId.RowSource = "Select Project.ProjectTrackingCd " & _
"FROM Project " & _
"WHERE Project.ProjectTypeCd = '" & Project_ProjectTypeCd.Value & "' " & _
"ORDER BY Project.ProjectTrackingCd;"

This allows the ParentProjectId to reflect only the type of projects selected in the Project Type ComboBox. If "Large" projects are selected then only those project numbers that have been classified as "Large" are shown in the next drop down box (the ParentProjectId). Same thing for "Medium" and "Small" projects.

Does that help/make sense?

Thanks.

 

[FoFa]

Here is what I would do.
Dump a record that has a problem.
Go in and select what you want.
Dump that same record and see what is different.
That may make things more clearer.

 

[wcboyd]

FoFa,

I am not sure how to dump a record in Access. Could you help me understand what you mean?

Thanks.

 

[FoFa]

Take a record and write SELECT * query selecting that primary key only.
Print/Export?save it.
Update using your combobox by selecting the correct value.
Run the query to dump the data again for the same record.
Compare

 

[wcboyd]

FoFa,

Thanks for the tip! I see the problem. The data I thought was there for all records is, in fact, only there for some.

Boy, do I feel dumb.

Thanks for the catch!