Question Form control error on query

[stevenb82]

Hi,

I am having an issue with a database application I created. I needed to add another query that could be controlled from combo box on a nested form.

The combo box is for dates for entries in a table. Which then filters the query based on the combo box selection. Easy enough stuff.

The problem I am having is that when I try to use the combo box as a criteria for the query using;

[Forms]![MasterForm]![NavigationSubform].[Form].[comboBox]

Access closes and wont let me use the reference to the combo box.

What has happened? Corrupt database? How do I fix it?

Thanks in advance.

 

[pr2-eugin]

Have you tried Compact & Repair?

 

[stevenb82]

Tried and it made no difference

 

[pr2-eugin]

Maybe try a Decompile.. Please make a BACKUP before you proceed..

 

[MSAccessRookie]

Hi,

I am having an issue with a database application I created. I needed to add another query that could be controlled from combo box on a nested form.

The combo box is for dates for entries in a table. Which then filters the query based on the combo box selection. Easy enough stuff.

The problem I am having is that when I try to use the combo box as a criteria for the query using;

[Forms]![MasterForm]![NavigationSubform].[Form].[comboBox]

Access closes and wont let me use the reference to the combo box.

What has happened? Corrupt database? How do I fix it?

Thanks in advance.

It may not be a Corrupt Database. Try making a new Combo Box in the Main Form and see if the Query can reference that. If it can, then there must be something wrong with the identification of the Combo Box in the SubForm. A common error to look out for in these cases would be the use of the Sub Form Name instead of the Control Name.

-- Rookie

 

[stevenb82]

pr2-eugin

Went to the link and tried the decompile. Made no difference unfortunately. But thanks for the info.

MSAccessRookie

I have done some whiteboxing on it and the only form which I cant access using the [Forms]! query criteria reference is the main/master form.

The problem occurs when I am in the design view of the query. When I start typing [Forms]![... As soon as I try to reference the masterform the msaccess stops and reopens the database asking me to save a backup of the database. I can type in a reference to any of the subforms no problem. Whether the references work is not the issue, its that when I reference the main navigation form that msaccess craps itself.

Thanks for the info though.

Anyone any ideas?

edit: I am using 2010 version.

 

[JHB]

What if you make a copy of the main/master form and try to make a reference to that form instead?
If you have other older versions of MS-Access installed on your computer, try to convert it to that older version and then open it with the older version. It had helped me sometimes.

 

[stevenb82]

That's not a bad idea JHB, I'll give that a go.. Thanks man

 

[stevenb82]

Copying the master navigation form didn't fix it. I found a workaround though. Luckily I keep backups every once in a while. I found one of my backups, deleted the master navigation form from the database, then imported the form from the working database back in.. Works now.

Thanks for all the help lads! Really appreciated it.

 

[pr2-eugin]

SPAM user daeldsir0 - Reported !