Append query & form

K

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.
 
L

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
 
Top