Form crashes when I make combo box a bound control

[Charlie Lou]

Access 2003
I have a form/subform. The form record source is the customer name/address.
The subform record is the order detail. The form/subform has worked fine
for a couple years. I attempted to change one of the fields, bound to the
underlying table, to a combo box instead of the user entering the data. The
combo box looks up the values in a separate table that has only one field.
The combo box works fine until I try to tie it to the order detail table. As
soon as I select the subform's underlying table field as the control source,
the database crashes. The whole database shuts down-- not just the form. I
have tried compacting/repair, and also did a decompile. I have narrowed it
down to the bound combo box (I believe). What am I missing? Does anyone
have any ideas/solutions? Let me know what other information you need....
thank you.

 

[Ken Snell MVP]

Might be a sign of corruption for the combo box control. Try deleting it and
recreating it.

 

[Charlie Lou]

Thank you for your reply.
I deleted the combo box, did a compact/repair, opened the database again and
again added the combo box. Again, it did the same thing- whole database shut
down.
--
Learning as I go...
Appreciate your assistance!

Might be a sign of corruption for the combo box control. Try deleting it and
recreating it.

 

[Ken Snell MVP]

I assume that the combobox is in the subform's Detail section.

Post the values of all the properties of the combo box, including what you
want the ControlSource to be. Let's see what might be lurking there...
--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

Thank you for your reply.
I deleted the combo box, did a compact/repair, opened the database again
and
again added the combo box. Again, it did the same thing- whole database
shut
down.

 

[Charlie Lou]

Yes-- combobox is in the subform's detail section. Let me know if I've given
you all of the information you needed.

Combo box values:
Name: Combo205
Control Source: PRODUCER
Decimal Places: Auto
Row Source Type: Table/Query
Row Source: SELECT [PRODUCER NAMES].[PRODUCER] FROM [PRODUCER NAMES] ORDER
BY [PRODUCER];
Bound Column: 1
Limit to List: No
Auto Expand: No
Enabled: Yes
Locked: No
Auto Expand: Yes
*Event properties are all blank
*Other properties still set to defaults

Would it have anything to do with the order detail field and table field are
both named "PRODUCER" ?

Thanks again!

 

[Ken Snell MVP]

I don't see anything in the combobox's properties. Please post the
Recordsource query for the subform.

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

Yes-- combobox is in the subform's detail section. Let me know if I've
given
you all of the information you needed.

Combo box values:
Name: Combo205
Control Source: PRODUCER
Decimal Places: Auto
Row Source Type: Table/Query
Row Source: SELECT [PRODUCER NAMES].[PRODUCER] FROM [PRODUCER NAMES] ORDER
BY [PRODUCER];
Bound Column: 1
Limit to List: No
Auto Expand: No
Enabled: Yes
Locked: No
Auto Expand: Yes
*Event properties are all blank
*Other properties still set to defaults

Would it have anything to do with the order detail field and table field
are
both named "PRODUCER" ?

Thanks again!


--

I assume that the combobox is in the subform's Detail section.

Post the values of all the properties of the combo box, including what
you
want the ControlSource to be. Let's see what might be lurking there...
--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/