Can't delete ComboBox

  • Thread starter Thread starter Leonard
  • Start date Start date
L

Leonard

I can't seem to delete a "ComboBox" on my form.

I have tried everything but no luck when I delete it I get
a "RunTime Error 3103" when I try to ad a new record.

I have deleted all references to the ComboBox on the form
itself and also in the underlying tables and queries.

I added "Can't Delete" to the end of the ComboBox name
on the form and in the related table, just in case I was
missing a reference to the original name somewhere.

As long as I keep the ComboBox on the form (over in a
corner out of the way) everything is fine but if I try to
delete the Control Source name in the properties window or
delete the control entirely I get the RunTime Error 3103
when I try to ad a record.

Any help appreciated

Leoanrd
 
I can't seem to delete a "ComboBox" on my form.

I have tried everything but no luck when I delete it I get
a "RunTime Error 3103" when I try to ad a new record.
Click to expand...

Have you Compacted and Repaired the database? You may need to recreate
the form. To save your labor, create a new blank form; set its
Recordsource and other properties to match this form; and copy and
paste all the controls from this damaged form to the new one. If you
have VBA code you'll need to open the Code window and copy and paste
it too. COMPILE THE DATABASE IMMEDIATELY when you have done so, before
closing or compacting it.
 
Thanks for responding John,

I tried your suggestions and it still doesn't work.

Now I have found out that the problem seems to jump
controls; i.e.:

I have two combo boxes that I have tried to delete, I can
delete one but when I try to delete the other I get the
RunTime Error. I can delete one but not the other.
And this inability to delete jumps from combo box to combo
box depending on which one gets deleted first.

I am really frustrated on this one and have spent many
hours trying to solve the problem.

Any and all suggestions welcome.
 
Back
Top