Lost Connection to ListBox

[alex]

Hello group,

I have 3 listboxes on a form. They get their value from a table
(three different ones).

These listboxes feed a subform using the subform control's default
value...this has been working perfectly.

I just recently changed the ID field in which the listboxes get their
data. After I did that, the controls on the subform stopped
recognizing the listboxes...i now get a #Error message in the
control. Nothing changed except for the length of the ID field. I
checked to make sure the bound column is the same!

Is there a way to reconnect these listboxes or do I need to recreate
them?

thanks,
alex

 

[John W. Vinson]

Hello group,

I have 3 listboxes on a form. They get their value from a table
(three different ones).

These listboxes feed a subform using the subform control's default
value...this has been working perfectly.

I just recently changed the ID field in which the listboxes get their
data. After I did that, the controls on the subform stopped
recognizing the listboxes...i now get a #Error message in the
control. Nothing changed except for the length of the ID field. I
checked to make sure the bound column is the same!

Is there a way to reconnect these listboxes or do I need to recreate
them?

thanks,
alex

What are they "connected" to? What is the Rowsource of each listbox (it should
be a query on the source table)? What is the Control Source (the field into
which the selected value is stored), and what is the Bound Column (which field
in the rowsource gets stored)? What field did you change, and in which table?

 

[alex]

What are they "connected" to? What is the Rowsource of each listbox (it should
be a query on the source table)? What is the Control Source (the field into
which the selected value is stored), and what is the Bound Column (which field
in the rowsource gets stored)? What field did you change, and in which table?
--

             John W. Vinson [MVP]- Hide quoted text -

- Show quoted text -

Thanks for replying back John...
They are connected to a table.
The rowsource is a query on the source table.
There is no control source (the listboxes are unbound). I have a
subform on the main form that get their value from these list boxes.
That's where I'm now seeing the #Error message. It's like they (the
bound textboxes on the subform) no longer recognize the listboxes!
The bound column is column 1, which is the table's ID field.
The field that I changed (in the source table) was the ID field. I
changed the ID's and made the field bigger (The ID field is not an
autonum).

I'm going to fool around with it now. Thanks for lookin' at this.
alex

 

[alex]

Thanks for replying back John...
They are connected to a table.
The rowsource is a query on the source table.
There is no control source (the listboxes are unbound).  I have a
subform on the main form that get their value from these list boxes.
That's where I'm now seeing the #Error message.  It's like they (the
bound textboxes on the subform) no longer recognize the listboxes!
The bound column is column 1, which is the table's ID field.
The field that I changed (in the source table) was the ID field.  I
changed the ID's and made the field bigger (The ID field is not an
autonum).

I'm going to fool around with it now.  Thanks for lookin' at this.
alex- Hide quoted text -

- Show quoted text -

I got it John...I just had to clear my head!
I changed the field length in the ID tables but failed to change the
field length in the destination table.
Thanks again for your help.
alex

 

[John W. Vinson]

I changed the field length in the ID tables but failed to change the
field length in the destination table.

Yep... they must match.