Error 3012 on unbound form 1

[Domino2]

I have an unbound form, with 4 controls on, 2 combo, 2 text boxes.

The two combo boxes have row sources to tables, choice selection items.

I am having trouble going from combo box to combo box,setting focus and using dropdown. I can move from a textbox after pressing return to a combo, and setting it's onfocus to dropdown. However if I use after update or click or exit on the combo event to move to the next combo, I get the error 3012 come up saying it cannot move as no record. None of the controls are bound to anything else. I want to go from textbox to combo, combo to combo, and combo to text box. I don't want to go from text box to combo to text box to combo.

Any ideas why it's doing this. Thanks

 

[dhookom]

Post your code.

Duane
Hook'D on Access
MS Access MVP

 

[missinglinq]

Works for me, without problems, in the OnClick, OnChange and AfterUpdate event, using 2003 and 2007.

By my reference, Error 3012 is "Object already exists." Since your Form is Unbound, the message about 'no record' sounds bogus. My guess would be that the Combobox is corrupted. We think/talk about Forms and even entire Databases being corrupt, but Controls can be corrupted, also.

The test for a corrupted Control is the same as the fix; you delete the Control then re-create it.

Linq ;0)>

The Missinglinq

Richmond, Virginia

The Devil's in the Details!

 

[Domino2]

Many thanks. Basically it's an unbound form, no code other than several attempts in event properties of the combos, ie on exit, after update, click. Also setting focus to combo before instructing dropdown. Also using dropdown on the combo "On got focus" etc etc.

So thanks I will try replacing controls, try removing the links to choice lists.

If nothing happens then I will try and import what's there into another form, or start again from scratch. I was going to try putting in an error handler to pass the error but thats a bodge.

Back on it tomorrow, Thanks again

 

[Domino2]

Thanks, something must have been corrupted. I tried removing all the combo references to tables (choice selection items) and all worked. So I relinked each combo back to their tables, and still worked. So I deleted both combos and added new ones, linked them up and no signs of any errors.

 

[missinglinq]

Glad you got it working again!

The Missinglinq

Richmond, Virginia

The Devil's in the Details!