Update Query not updating all field

  • Thread starter Thread starter Briggs
  • Start date Start date
B

Briggs

Hi,
I am a novice. I have created a several FORMS which add
new records and updates records in several tables.

I am able to get my macros and the forms to append
correctly, with the APPEND queries to load new records.

The problem I am having is loading the changes. I created
a FORM and buttoms (using macros) to update my table and
then load the changes to a transaction table.

The problem is that when the macro executes the UPDATE
query. All fields are not updated. I tried manually
running the query and it may only update two columns. Then
I run it again and it updates one additonal column. Then
maybe it will updates an entire row.

Please help. It is very inconsistant the way it working.

Thanks,
Betty
 
I am a novice. I have created a several FORMS which add
new records and updates records in several tables.
Click to expand...

Unbound forms using macros? That's a rather *advanced* technique;
normally no queries and no code are needed if you just use a bound
form!
I am able to get my macros and the forms to append
correctly, with the APPEND queries to load new records.

The problem I am having is loading the changes. I created
a FORM and buttoms (using macros) to update my table and
then load the changes to a transaction table.
Click to expand...

Please post the steps of the macro and the SQL of the append query. As
I say, you seem to be going all around the barn to do something pretty
simple, and I'm not sure why you're doing it - much less why it's not
working!
 
Back
Top