Query too complex..?

[kenjoswe]

Hi all,

I have two queries in a database.
A select query which is connected to a form and a update query.
The update query is a copy of the select query except for the update field.

The update query is to complex to run.

Is there a way to just update what is displayed in the form?


/Kent J

 

[tlbroadbent]

When you run the Update query do you get the error message that it is "too complex." If yes, the problem may be the size of the query rather than the complexity. Try to shorten the table names by using aliases. Eliminate unnecessary columns. Avoid using lots of functions if possible. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[BNPMike]

kenjoswe

Sorry you've got me here. I can't visualise what you are doing.

If you have a select query attached to a form, if you update the field on the form it will update the database if that view is updatable. If it's not then it won't. But then it won't if you just run the same thing as a bare SQL Query. Can you expand a bit on what you are doing? mike.stephens@bnpparibas.com

 

[kenjoswe]

BNPMike,

This is what I try to do:

I have a form (FrmSearch) with eight droplists on.
The user can select any combination of the droplists to update or view a recordset.

In order to do this I have a query with all columns represented that are used from the droplists.

The typical criteria for one of the eight columns looks like this:
[Forms]![FrmSearch]![DropList1] or [Forms]![FrmSearch]![DropList1] is null

The above criteria generates a great deal of code in Access.
The select query works fine. I have also a copy (update query) of that select query but with three update fields.

If I try to run the update query I get a message:
"The query is to complex".

I have also tried to have the select query as a base for the update query. This works but only if I use a single update column - and I need three.

/Kent J.