VB help websites?

[anyaj]

Could you recommend forums (fora?) where I could find an answer to a VB (in Access) question? I've looked on Google Groups, but it didn't have an answer for me.

I'll post my VB question here...

I have a combo box on a form (in Access) that won't let me select anything in the combo box's list. I created the form from a pre-existing form, whose combo box works fine. So I know it's not the properties of said combo box, because I didn't change any.

Any advice is appreciated.

[Bama Gambler]

I'll take a quick stab...does the new form use the same table/query for the data set as the orginal form? If not, then the data for the combo box on the new form might not exist.

[anyaj]

Yes, same query. Thank you, though! :)

[Bama Gambler]

It won't let you select anything from the list or it doesn't show anything in the list?

[Brad Gile]

Could you recommend forums (fora?) where I could find an answer to a VB (in Access) question? I've looked on Google Groups, but it didn't have an answer for me.

I'll post my VB question here...

I have a combo box on a form (in Access) that won't let me select anything in the combo box's list. I created the form from a pre-existing form, whose combo box works fine. So I know it's not the properties of said combo box, because I didn't change any.

Any advice is appreciated.

Try the LSOFT lists. For example: http://www.lsoft.com/scripts/wl.exe?SL1=ACCESS-L&H=PEACH.EASE.LSOFT.COM

Brad
"Karate ni sente nashi. There is no first strike in karate."-Gichin Funakoshi
"Neither is there a second!"-Brad Gile

[Bama Gambler]

The important properties are as follows:
Control Source - this links to the table
Row Source - this is the choices that are displayed
Enabled - this must be true or you want be able to select anything
Locked - this must be false

[anyaj]

It won't let you select anything from the list or it doesn't show anything in the list?

I have a full list, and it even highlights when I mouse iver the list, but I can't select anything from the list.

[anyaj]

The important properties are as follows:
Control Source - this links to the table
Row Source - this is the choices that are displayed
Enabled - this must be true or you want be able to select anything
Locked - this must be false

Row Source = "SELECT FieldName, Description FROM " & _
tablenameVariable & " Order by FieldName"
Control Source ="Fieldname"
Enabled=true
Locked =No

[Bama Gambler]

I grapsing at straws, but try creating a new combo box with the four properties the same as above.

[anyaj]

I grapsing at straws, but try creating a new combo box with the four properties the same as above.

BG, thanks so much for your help. It WAS my select statement in my rowsource. I had renamed columns in my table, and this sql statement was the only place I forgot to fix the column names in the code.

Thanks Brad, as well (also BG!).