"Statement Too Complex"?????

[JJ]

I have used SQL code to copy and append an existing record, however I get the
"Statement Too Complex" message. Basically, I am just trying to copy a record
from the table and append it to the bottom of the same table. However, the
table has a primary key ([NumberID]), so I don't believe I can just use this
code:

'"INSERT INTO [*Master_tbl] " & _
'"SELECT [*Master_tbl].* " & _
'"FROM [*Master_tbl] " & _
'"WHERE [*Master_tbl].[NumberID] = " & [Forms]![*Master_frm]![NumbertID]

So I tried to use the sequel code and use all the fields in the table, which
is about 120 fields, and leave out the [NumberID] in both the INSERT INTO and
SELECT statement. But every time i try to paste the code in or try and save,
it gives me the error message "Statment Too Complex".
I am sure I am probably making this more difficult than needed, I just need
to copy a record to the bottom of a table. Any suggestions????

 

[Klatuu]

Inserting into yourself not only sounds too complex, it sounds very painful.
I doubt very seriously this will work. You might try listing all fields
with the exception of the primary key instead of using the *.

I always hate it when someone asks me "why do you want to do that?" In this
case, my curiousity has got the best of me. I can't for the life of me
figure out why you would want to copy a row from a table to the same table.
I would appreciate your letting me know.

 

[Ofer]

Assuming that the Key field is a counter

Dim MyDb As Dao.DataBase, MyRec As Dao.Recordset, MyRec2 As Dao.RecordSet

Set MyDb = currentdb
Set MyRec2 = MyDb.OpenRecordSet ("SELECT [*Master_tbl].* FROM
[*Master_tbl]", dbOpenDynaset, dbSeeChanges)
Set MyRec = MyDb.OpenRecordset("SELECT [*Master_tbl].* FROM [*Master_tbl]
WHERE [*Master_tbl].[NumberID] = " & [Forms]![*Master_frm]![NumbertID],
dbOpenDynaset, dbSeeChanges)
While Not MyRec.Eof
MyRec2.AddNew
MyRec2!Field1Name = MyRec!Field1Name
MyRec2!Field2Name = MyRec!Field2Name
MyRec2!Field3Name = MyRec!Field3Name
MyRec2!Field4Name = MyRec!Field4Name
MyRec2.Update
MyRec.MoveNext
Wend

 

[tina]

well, it should work. i tested on a table/form that i had handy, as

INSERT INTO tblAddInv ( DateAdded, FormNumber, AmountAdded )
SELECT DateAdded, FormNumber, AmountAdded
FROM tblAddInv
WHERE ID=[Forms]![frmAddInv]![ID];

frmAddInv is bound to tblAddInv, and i ran the Append query by clicking a
command button. take a look at the short SQL above, and see if anything
strikes you as different from the syntax of the SQL in *your* Append query -
other than the number of fields involved, of course. (btw, the query will
work the same if the table name is prefixed to each fieldname, such as
tblAddInv.ID. it's just that in a single-table query, it's not necessary, so
i deleted the table prefixes to make it easier to read.)

the only thing that caught my attention was your table and form names - do
they really begin with an asterisk (*)? if not, why is one included in each
name in the SQL statement?

hth

 

['69 Camaro]

Hi, JJ.

Most likely, you have a syntax error in the SQL statement and when Jet tries
to parse it, it's too strange for Jet to handle. (That usage of the asterisk
comes to mind, because you may have accidentally multiplied values together,
instead of concatenating them into a string.) It appears that you have a
typo, as well. Is the name of the text control on the form NumbertID or
NumberID? I'll assume it's the latter in the example below.

Also, if you have 120 fields in a table, then it's very likely that the
table isn't normalized, so you may want to take a closer look at why there
are so many fields. To keep you from having to copy/paste the names of all
of those fields in the query, try the following procedure to copy a record:

Public Sub copyRecord()

On Error GoTo ErrHandler

Dim recSet As DAO.Recordset
Dim rows() As Variant
Dim sqlStmt As String
Dim idx As Long
Dim fOpenedRecSet As Boolean

sqlStmt = "SELECT * " & _
"FROM [*Master_tbl] " & _
"WHERE (NumberID = " & Forms![*Master_frm]!NumberID.Value & ")"

Set recSet = CurrentDb().OpenRecordset(sqlStmt)
fOpenedRecSet = True
rows() = recSet.GetRows(1)
recSet.AddNew

For idx = 0 To (recSet.Fields.Count - 1)
If (recSet.Fields(idx).Name <> "NumberID") Then
recSet.Fields(idx).Value = rows(idx, 0)
End If
Next idx

recSet.Update

CleanUp:

If (fOpenedRecSet) Then
recSet.Close
fOpenedRecSet = False
End If

Set recSet = Nothing
Erase rows()

Exit Sub

ErrHandler:

MsgBox "Error in copyRecord( )." & vbCrLf & vbCrLf & _
"Error #" & Err.Number & vbCrLf & vbCrLf & Err.Description
Err.Clear
GoTo CleanUp

End Sub

This procedure assumes that the NumberID field is numerical, not text or a
date, and that the *Master_frm form is open and that the NumberID indicated
already exists in the *Master_tbl table.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.

I have used SQL code to copy and append an existing record, however I get the
"Statement Too Complex" message. Basically, I am just trying to copy a record
from the table and append it to the bottom of the same table. However, the
table has a primary key ([NumberID]), so I don't believe I can just use this
code:

'"INSERT INTO [*Master_tbl] " & _
'"SELECT [*Master_tbl].* " & _
'"FROM [*Master_tbl] " & _
'"WHERE [*Master_tbl].[NumberID] = " & [Forms]![*Master_frm]![NumbertID]

So I tried to use the sequel code and use all the fields in the table, which
is about 120 fields, and leave out the [NumberID] in both the INSERT INTO and
SELECT statement. But every time i try to paste the code in or try and save,
it gives me the error message "Statment Too Complex".
I am sure I am probably making this more difficult than needed, I just need
to copy a record to the bottom of a table. Any suggestions????

 

[JJ]

Thanks everyone for your expert advise. I was able to get it to work. As Tina
suggested, I took out the table name in the select statement and it works
fine. I am unsure if it was the table name over and over that was causing it
to be complex or not, but taking out the table identifier in the select
statement reduced the code by 120 words. In answer to Klatuu: I am using the
duplicate record as a template for another record, because there are 120
different fields, i will just replicate them and the user can change the one
or two fields that are different each time. Thanks again everyone for your
help!

Hi, JJ.

Most likely, you have a syntax error in the SQL statement and when Jet tries
to parse it, it's too strange for Jet to handle. (That usage of the asterisk
comes to mind, because you may have accidentally multiplied values together,
instead of concatenating them into a string.) It appears that you have a
typo, as well. Is the name of the text control on the form NumbertID or
NumberID? I'll assume it's the latter in the example below.

Also, if you have 120 fields in a table, then it's very likely that the
table isn't normalized, so you may want to take a closer look at why there
are so many fields. To keep you from having to copy/paste the names of all
of those fields in the query, try the following procedure to copy a record:

Public Sub copyRecord()

On Error GoTo ErrHandler

Dim recSet As DAO.Recordset
Dim rows() As Variant
Dim sqlStmt As String
Dim idx As Long
Dim fOpenedRecSet As Boolean

sqlStmt = "SELECT * " & _
"FROM [*Master_tbl] " & _
"WHERE (NumberID = " & Forms![*Master_frm]!NumberID.Value & ")"

Set recSet = CurrentDb().OpenRecordset(sqlStmt)
fOpenedRecSet = True
rows() = recSet.GetRows(1)
recSet.AddNew

For idx = 0 To (recSet.Fields.Count - 1)
If (recSet.Fields(idx).Name <> "NumberID") Then
recSet.Fields(idx).Value = rows(idx, 0)
End If
Next idx

recSet.Update

CleanUp:

If (fOpenedRecSet) Then
recSet.Close
fOpenedRecSet = False
End If

Set recSet = Nothing
Erase rows()

Exit Sub

ErrHandler:

MsgBox "Error in copyRecord( )." & vbCrLf & vbCrLf & _
"Error #" & Err.Number & vbCrLf & vbCrLf & Err.Description
Err.Clear
GoTo CleanUp

End Sub

This procedure assumes that the NumberID field is numerical, not text or a
date, and that the *Master_frm form is open and that the NumberID indicated
already exists in the *Master_tbl table.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.

I have used SQL code to copy and append an existing record, however I get the
"Statement Too Complex" message. Basically, I am just trying to copy a record
from the table and append it to the bottom of the same table. However, the
table has a primary key ([NumberID]), so I don't believe I can just use this
code:

'"INSERT INTO [*Master_tbl] " & _
'"SELECT [*Master_tbl].* " & _
'"FROM [*Master_tbl] " & _
'"WHERE [*Master_tbl].[NumberID] = " & [Forms]![*Master_frm]![NumbertID]

So I tried to use the sequel code and use all the fields in the table, which
is about 120 fields, and leave out the [NumberID] in both the INSERT INTO and
SELECT statement. But every time i try to paste the code in or try and save,
it gives me the error message "Statment Too Complex".
I am sure I am probably making this more difficult than needed, I just need
to copy a record to the bottom of a table. Any suggestions????

 

[tina]

As Tina

suggested, I took out the table name in the select statement and it works
fine. I am unsure if it was the table name over and over that was causing it
to be complex or not, but taking out the table identifier in the select
statement reduced the code by 120 words.

hmm, well, that shouldn't have made a difference, unless you hand-wrote the
SQL and made a mistake in the syntax involving the "FROM" table's name. but
whatever and however, you did get it to work so that's good.

i definitely agree with Gunny, though - a table with 120 fields is almost
guaranteed to *not* be normalized. especially due to your mention that out
of 120 fields, each record has a change in only one or two. you may have
solved this problem, but i predict you're going to keep running into issues
due to poor table design. i strongly recommend that you read up on the
principles of data modeling and normalization. if you don't apply what you
learn in this database, you'll be ready to make your next one better. see
http://home.att.net/~california.db/tips.html#aTip1
for more information.

hth

Thanks everyone for your expert advise. I was able to get it to work. As Tina
suggested, I took out the table name in the select statement and it works
fine. I am unsure if it was the table name over and over that was causing it
to be complex or not, but taking out the table identifier in the select
statement reduced the code by 120 words. In answer to Klatuu: I am using the
duplicate record as a template for another record, because there are 120
different fields, i will just replicate them and the user can change the one
or two fields that are different each time. Thanks again everyone for your
help!

Hi, JJ.

Most likely, you have a syntax error in the SQL statement and when Jet tries
to parse it, it's too strange for Jet to handle. (That usage of the asterisk
comes to mind, because you may have accidentally multiplied values together,
instead of concatenating them into a string.) It appears that you have a
typo, as well. Is the name of the text control on the form NumbertID or
NumberID? I'll assume it's the latter in the example below.

Also, if you have 120 fields in a table, then it's very likely that the
table isn't normalized, so you may want to take a closer look at why there
are so many fields. To keep you from having to copy/paste the names of all
of those fields in the query, try the following procedure to copy a record:

Public Sub copyRecord()

On Error GoTo ErrHandler

Dim recSet As DAO.Recordset
Dim rows() As Variant
Dim sqlStmt As String
Dim idx As Long
Dim fOpenedRecSet As Boolean

sqlStmt = "SELECT * " & _
"FROM [*Master_tbl] " & _
"WHERE (NumberID = " & Forms![*Master_frm]!NumberID.Value & ")"

Set recSet = CurrentDb().OpenRecordset(sqlStmt)
fOpenedRecSet = True
rows() = recSet.GetRows(1)
recSet.AddNew

For idx = 0 To (recSet.Fields.Count - 1)
If (recSet.Fields(idx).Name <> "NumberID") Then
recSet.Fields(idx).Value = rows(idx, 0)
End If
Next idx

recSet.Update

CleanUp:

If (fOpenedRecSet) Then
recSet.Close
fOpenedRecSet = False
End If

Set recSet = Nothing
Erase rows()

Exit Sub

ErrHandler:

MsgBox "Error in copyRecord( )." & vbCrLf & vbCrLf & _
"Error #" & Err.Number & vbCrLf & vbCrLf & Err.Description
Err.Clear
GoTo CleanUp

End Sub

This procedure assumes that the NumberID field is numerical, not text or a
date, and that the *Master_frm form is open and that the NumberID indicated
already exists in the *Master_tbl table.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.

I have used SQL code to copy and append an existing record, however I get the
"Statement Too Complex" message. Basically, I am just trying to copy a record
from the table and append it to the bottom of the same table. However, the
table has a primary key ([NumberID]), so I don't believe I can just use this
code:

'"INSERT INTO [*Master_tbl] " & _
'"SELECT [*Master_tbl].* " & _
'"FROM [*Master_tbl] " & _
'"WHERE [*Master_tbl].[NumberID] = " & [Forms]![*Master_frm]![NumbertID]

So I tried to use the sequel code and use all the fields in the table, which
is about 120 fields, and leave out the [NumberID] in both the INSERT INTO and
SELECT statement. But every time i try to paste the code in or try and save,
it gives me the error message "Statment Too Complex".
I am sure I am probably making this more difficult than needed, I just need
to copy a record to the bottom of a table. Any suggestions????

 

[David C. Holley]

Maybe its to duplicate a reservation in a reservation DB?

Inserting into yourself not only sounds too complex, it sounds very painful.
I doubt very seriously this will work. You might try listing all fields
with the exception of the primary key instead of using the *.

I always hate it when someone asks me "why do you want to do that?" In this
case, my curiousity has got the best of me. I can't for the life of me
figure out why you would want to copy a row from a table to the same table.
I would appreciate your letting me know.

:

I have used SQL code to copy and append an existing record, however I get the
"Statement Too Complex" message. Basically, I am just trying to copy a record
from the table and append it to the bottom of the same table. However, the
table has a primary key ([NumberID]), so I don't believe I can just use this
code:

'"INSERT INTO [*Master_tbl] " & _
'"SELECT [*Master_tbl].* " & _
'"FROM [*Master_tbl] " & _
'"WHERE [*Master_tbl].[NumberID] = " & [Forms]![*Master_frm]![NumbertID]

So I tried to use the sequel code and use all the fields in the table, which
is about 120 fields, and leave out the [NumberID] in both the INSERT INTO and
SELECT statement. But every time i try to paste the code in or try and save,
it gives me the error message "Statment Too Complex".
I am sure I am probably making this more difficult than needed, I just need
to copy a record to the bottom of a table. Any suggestions????

 

[David C. Holley]

What are the 120 fields?

As Tina
suggested, I took out the table name in the select statement and it works
fine. I am unsure if it was the table name over and over that was causing
it

to be complex or not, but taking out the table identifier in the select
statement reduced the code by 120 words.

hmm, well, that shouldn't have made a difference, unless you hand-wrote the
SQL and made a mistake in the syntax involving the "FROM" table's name. but
whatever and however, you did get it to work so that's good.

i definitely agree with Gunny, though - a table with 120 fields is almost
guaranteed to *not* be normalized. especially due to your mention that out
of 120 fields, each record has a change in only one or two. you may have
solved this problem, but i predict you're going to keep running into issues
due to poor table design. i strongly recommend that you read up on the
principles of data modeling and normalization. if you don't apply what you
learn in this database, you'll be ready to make your next one better. see
http://home.att.net/~california.db/tips.html#aTip1
for more information.

hth

Thanks everyone for your expert advise. I was able to get it to work. As
Tina

suggested, I took out the table name in the select statement and it works
fine. I am unsure if it was the table name over and over that was causing
it

to be complex or not, but taking out the table identifier in the select
statement reduced the code by 120 words. In answer to Klatuu: I am using
the

duplicate record as a template for another record, because there are 120
different fields, i will just replicate them and the user can change the
one

or two fields that are different each time. Thanks again everyone for your
help!

:

Hi, JJ.

Most likely, you have a syntax error in the SQL statement and when Jet

tries

to parse it, it's too strange for Jet to handle. (That usage of the

asterisk

comes to mind, because you may have accidentally multiplied values

together,

instead of concatenating them into a string.) It appears that you have

a

typo, as well. Is the name of the text control on the form NumbertID or
NumberID? I'll assume it's the latter in the example below.

Also, if you have 120 fields in a table, then it's very likely that the
table isn't normalized, so you may want to take a closer look at why

there

are so many fields. To keep you from having to copy/paste the names of

all

of those fields in the query, try the following procedure to copy a

record:

Public Sub copyRecord()

On Error GoTo ErrHandler

Dim recSet As DAO.Recordset
Dim rows() As Variant
Dim sqlStmt As String
Dim idx As Long
Dim fOpenedRecSet As Boolean

sqlStmt = "SELECT * " & _
"FROM [*Master_tbl] " & _
"WHERE (NumberID = " & Forms![*Master_frm]!NumberID.Value & ")"

Set recSet = CurrentDb().OpenRecordset(sqlStmt)
fOpenedRecSet = True
rows() = recSet.GetRows(1)
recSet.AddNew

For idx = 0 To (recSet.Fields.Count - 1)
If (recSet.Fields(idx).Name <> "NumberID") Then
recSet.Fields(idx).Value = rows(idx, 0)
End If
Next idx

recSet.Update

CleanUp:

If (fOpenedRecSet) Then
recSet.Close
fOpenedRecSet = False
End If

Set recSet = Nothing
Erase rows()

Exit Sub

ErrHandler:

MsgBox "Error in copyRecord( )." & vbCrLf & vbCrLf & _
"Error #" & Err.Number & vbCrLf & vbCrLf & Err.Description
Err.Clear
GoTo CleanUp

End Sub

This procedure assumes that the NumberID field is numerical, not text or

a

date, and that the *Master_frm form is open and that the NumberID

indicated

already exists in the *Master_tbl table.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message

will

be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the

question

"Did this post answer your question?" at the bottom of the message,

which

adds your question and the answers to the database of answers. Remember

that

questions answered the quickest are often from those who have a history

of

rewarding the contributors who have taken the time to answer questions
correctly.


:


I have used SQL code to copy and append an existing record, however I

get the

"Statement Too Complex" message. Basically, I am just trying to copy a

record

from the table and append it to the bottom of the same table. However,

the

table has a primary key ([NumberID]), so I don't believe I can just

use this

code:

'"INSERT INTO [*Master_tbl] " & _
'"SELECT [*Master_tbl].* " & _
'"FROM [*Master_tbl] " & _
'"WHERE [*Master_tbl].[NumberID] = " &

[Forms]![*Master_frm]![NumbertID]

So I tried to use the sequel code and use all the fields in the table,

which

is about 120 fields, and leave out the [NumberID] in both the INSERT

INTO and

save,

need

 

[JJ]

Mostly State and Country check boxes.

What are the 120 fields?

As Tina
suggested, I took out the table name in the select statement and it works
fine. I am unsure if it was the table name over and over that was causing
it

to be complex or not, but taking out the table identifier in the select
statement reduced the code by 120 words.

hmm, well, that shouldn't have made a difference, unless you hand-wrote the
SQL and made a mistake in the syntax involving the "FROM" table's name. but
whatever and however, you did get it to work so that's good.

i definitely agree with Gunny, though - a table with 120 fields is almost
guaranteed to *not* be normalized. especially due to your mention that out
of 120 fields, each record has a change in only one or two. you may have
solved this problem, but i predict you're going to keep running into issues
due to poor table design. i strongly recommend that you read up on the
principles of data modeling and normalization. if you don't apply what you
learn in this database, you'll be ready to make your next one better. see
http://home.att.net/~california.db/tips.html#aTip1
for more information.

hth

Thanks everyone for your expert advise. I was able to get it to work. As
Tina

suggested, I took out the table name in the select statement and it works
fine. I am unsure if it was the table name over and over that was causing
it

to be complex or not, but taking out the table identifier in the select
statement reduced the code by 120 words. In answer to Klatuu: I am using
the

duplicate record as a template for another record, because there are 120
different fields, i will just replicate them and the user can change the
one

or two fields that are different each time. Thanks again everyone for your
help!

:


Hi, JJ.

Most likely, you have a syntax error in the SQL statement and when Jet
tries

to parse it, it's too strange for Jet to handle. (That usage of the
asterisk

comes to mind, because you may have accidentally multiplied values
together,

instead of concatenating them into a string.) It appears that you have
a

typo, as well. Is the name of the text control on the form NumbertID or
NumberID? I'll assume it's the latter in the example below.

Also, if you have 120 fields in a table, then it's very likely that the
table isn't normalized, so you may want to take a closer look at why
there

are so many fields. To keep you from having to copy/paste the names of
all

of those fields in the query, try the following procedure to copy a
record:

Public Sub copyRecord()

On Error GoTo ErrHandler

Dim recSet As DAO.Recordset
Dim rows() As Variant
Dim sqlStmt As String
Dim idx As Long
Dim fOpenedRecSet As Boolean

sqlStmt = "SELECT * " & _
"FROM [*Master_tbl] " & _
"WHERE (NumberID = " & Forms![*Master_frm]!NumberID.Value & ")"

Set recSet = CurrentDb().OpenRecordset(sqlStmt)
fOpenedRecSet = True
rows() = recSet.GetRows(1)
recSet.AddNew

For idx = 0 To (recSet.Fields.Count - 1)
If (recSet.Fields(idx).Name <> "NumberID") Then
recSet.Fields(idx).Value = rows(idx, 0)
End If
Next idx

recSet.Update

CleanUp:

If (fOpenedRecSet) Then
recSet.Close
fOpenedRecSet = False
End If

Set recSet = Nothing
Erase rows()

Exit Sub

ErrHandler:

MsgBox "Error in copyRecord( )." & vbCrLf & vbCrLf & _
"Error #" & Err.Number & vbCrLf & vbCrLf & Err.Description
Err.Clear
GoTo CleanUp

End Sub

This procedure assumes that the NumberID field is numerical, not text or
a

date, and that the *Master_frm form is open and that the NumberID
indicated

already exists in the *Master_tbl table.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message
will

be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the
question

"Did this post answer your question?" at the bottom of the message,
which

adds your question and the answers to the database of answers. Remember
that

questions answered the quickest are often from those who have a history
of

rewarding the contributors who have taken the time to answer questions
correctly.


:


I have used SQL code to copy and append an existing record, however I

get the

"Statement Too Complex" message. Basically, I am just trying to copy a
record

from the table and append it to the bottom of the same table. However,
the

table has a primary key ([NumberID]), so I don't believe I can just

use this

code:

'"INSERT INTO [*Master_tbl] " & _
'"SELECT [*Master_tbl].* " & _
'"FROM [*Master_tbl] " & _
'"WHERE [*Master_tbl].[NumberID] = " &
[Forms]![*Master_frm]![NumbertID]

So I tried to use the sequel code and use all the fields in the table,
which

is about 120 fields, and leave out the [NumberID] in both the INSERT

INTO and

SELECT statement. But every time i try to paste the code in or try and
save,

it gives me the error message "Statment Too Complex".
I am sure I am probably making this more difficult than needed, I just
need

to copy a record to the bottom of a table. Any suggestions????

 

[Tim Ferguson]

Mostly State and Country check boxes.

<sharp intake of breath...>


Tim F

 

[tina]

<sharp intake of breath...>

LOL

<sharp intake of breath...>


Tim F

 

[David C. Holley]

Let me guess, you're using the State & Country check boxes to indicate
to which State or Country the record applies? In short, I (and others)
would *****STRONGLY***** recommend that you spin out the data into a
separate table.