Combobox Rowsource yields Unexpected results

[JamesDSM50328]

Hi, I have a unbound form that has multiple comboboxes that when selected sets another combobox with it's options, 1 combobox after the rowsource is updated does not have all of the information in the next combobox. This is only happening to a select few. The linked tables on reflect all of the data.
Any Suggestions?

Private Sub cboAttr1_AfterUpdate()
On Error Resume Next
 Select Case cboAttr1.Value
   Case "Mktg Pgm Group"
     cboValue1.RowSource  "dbo_market_program_group_ref"
     cboValue1.ColumnCount = 1
 End Select
End Sub

 

[lameid]

Interesting... I have only altered selection records displayed but never changed the row source.

Have you tried requerying the combobox?

cboValue1.requery

 

[TheAceMan1]

How are ya JamesDSM50328 . . .

. . . and how about:

[blue]   cboValue1.RowSource [purple][b]=[/b][/purple] "dbo_market_program_group_ref"[/blue]

If your still having problems post the RowSource for [blue]dbo_market_program_group_ref[/blue] . . .

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[JamesDSM50328]

Thanks for your responses, the cboValue1.Rowsource is as you have it, not sure what happend to the "=" sign when I pasted it in, but still the same results, and I have also have tried thr requery and still does not display all of the correct records.

The "dbo_market_program_group_ref" is a linked table. Any additional ideas?

 

[lameid]

Just looked at help for rowsource. How about:

cboValue1.RowSourceType = "Table/Query"
cboValue1.RowSource  = "dbo_market_program_group_ref"

 

[JamesDSM50328]

Thanks lameid, I just tried that, still the samething, it looks like I am getting about half of the items that should be populating into the combo, data is still not complete.

Case "Mktg Pgm Group"
     cboValue1.RowSourceType = "Table/Query"
     cboValue1.RowSource = "dbo_market_program_group_ref"
     cboValue1.ColumnCount = 1

End Select

cboValue1.Requery

 

[lameid]

Does your table return all the results when you open the link?

I was confused about it not displaying all the data, I thought it wouldn't display data...

It should really just work... Is it maybe just returning the top so many values?

 

[JamesDSM50328]

Thanks again for your responses.
When I open the table it display all the data, but once it is displayed in the combo it removes part of the records. It works on my computer fine but there are a quite a few other people that are having the issue, but if the data can't be trusted...

there are not a lot of items for the combo only around 60 so I don't think it has too much data trying to be displayed.

 

[lameid]

Works differently on different machines...

The other machines may need updated ODBC drivers or if you used a DSN for your link, may have an entirely different database or server specified.