Access cannot find object "*"

[Cyd44]

I have created a navigation form "frmNavigation" to use as a menu for a dbase. When I use it If I press one of the buttons I get the above error and then it opens the correct form. If I try to open the frmNavigation in design view I also get the same error and then it opens in design view?

I have tried taking out all events and macros and the form is now empty of any commands (only the design info remanis). Even so, if I press a button I get the same error.

It does not happen on all buttons, just 2?

Can anyone help here?

[Stewart Ross]

Please post the VBA code for the relevant button's On Click events. Can't answer you without it.

-Stewart

[Cyd44]

None of the buttons have any code behind them. I have simply created the form with no events behind any of the buttons as yet.

However, if I try to open the form in design view I get the error and if I open in form view and press buttons, I get an error on some and nothing on others

[NeoPa]

If you have no VBA code then you certainly have at least one control connected to either SQL code or a QueryDef. Please post the SQL of that.

As Stewart says, if you don't tell us anything about your problem it'll be somewhat complicated to help you.

[Cyd44]

I fully appreciate your attempts to help me and apologise on the fact that I am very new to access. The Form I have created simply has the buttons without any events entered the VB code behind the form is as follows:-

Option Compare Database


This is the only code visible as I have deleted all of the original events in order to get back to the basic proble. I know it is illogical and I have pulled my hair out looking for any residual code for this form but cannot find any. Why then should I get the error when either trying to open in design view or when pressing 2 of the empty buttons on form view????
Sorry if I appear to be thick but the logic here is beyond me as I am only opening a form to be used as a menu?

[ADezii]

Why not Upload the DB with only the Form present?

[Cyd44]

Will try that Adezil. I will let you know

[Cyd44]

Have export just the form to an empty database and am still getting the error

[ADezii]

@Cyd44:
I meant to Upload the Database with the Empty Form to this Site as an Attachment.

[Cyd44]

Would love to but I don not have winzip on my system (only have jZip). This site will not let me upload jZip file.

The error is illogical as I have only got a blank form now and it still gives me an error on trying to open the design view. It does go to the view and will let me change views without error after the first time.

There is absolutely no code that I can see which could upset the system but it is obviously trying to look for some object or other.

I am using Access 2010, do you know of any bug in this version

[Cyd44]

Will go on line and purchase winZip so that I can send you the dabase

[Cyd44]

Here is the dbase, many thanks for having a look

[ADezii]

Sorry Cyd44, but I need it in an earlier Version, say 2003.

[Cyd44]

I only have 2010 I am afraid, this is a new comuter

[NeoPa]

NeoPa:
If you have no VBA code then you certainly have at least one control connected to either SQL code or a QueryDef. Please post the SQL of that.

You will find a control somewhere on your form, a ListBox or ComboBox control, which is populated by some SQL. Look in the Control Source property. Your problem is almost certainly to be found within that SQL (or QueryDef name).

BTW I expect you can create a blank db in 2003 form, even in 2010, then import the form into that new DB for posting in here.

[Cyd44]

Thanks for trying guys. The error is a mistery. However, I have built a new form and populated this and it works fine.

Still at a loss about the old form though.

Thanks to everyone who has tried to help

[NeoPa]

Never mind. At least you have a working solution :-)