Append query & form

[kmhnhsuk]

Hi,
I have a problem with a form and an append query.

I am designing an Accounts package, I have a bank reconciliation form, that
basically appends records from tblCashbook where the [Bank Rec] Yes/No field
= 0 i.e. Not ticked to tblBankRec (form based on this table) This works as it
should.

However, when I attempt to tick all items on the form as reconciled i.e.
[Bank Rec]field has a value of 1, and subsequently run an Append query to
append all records from tblBankRec to tblCashBook it works okay until I
included this append query in a macro or attach it to a button in the form.
Then the data appended seems to lose the value in the Yes/No field.

I have no clue as to why this happens as it works just fine if you run the
query manually and check the results.

 

[[MVP] S.Clark]

What do you mean by "including the append query in a macro or attach it to a
button"

Explain further the usage.


--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting

 

[lumineaux]

I had the same problem and inestigated like this:

First, I opened the macro in design view, then I clicked on the "single
step" button, just next to the "run" button, and I followed my macro step by
step until I was past the "update query," I then halted the macro and went to
my table. Sure enough, the data was there.

Next, I manually ran each following query in succession until I found the
errant query. In my case I had a delete query whos paramaters were catching
my new data and, of course, deleting it. I fixed that query and all is well.

I hope this helps