update query from ACCESS 2002 doesn't work under 2003

  • Thread starter Thread starter ljubo lecic via AccessMonster.com
  • Start date Start date
L

ljubo lecic via AccessMonster.com

I have the update query, designed in ACCESS 2002, which is called from the
form. Everything works perfectly until
I transfer my aplication to a system running ACCESS 2003.
Under ACCESS 2003 query parameter "Forms!duznici!sifra"
which is used to transfer data from the form to the query behaves as it was
always NULL instead of actual value from the form.

The Query is:

UPDATE duznici SET ukupno_zaduzenje = ukupno_zaduzenje+Forms!duznici!
zaduzenja!upc
WHERE sifra=Forms!duznici!sifra;

"zaduzenja" is a subform within "duznici" form

I repeat that this query works properly under ACCESS 2002 but when
transfered to ACCESS 2003 it doesn't work
at all.
I NEED AN URGENT HELP
 
Thanks a lot Mr Dinh.
I have just rewritten my code and everything is
OK now. Problem solved - software sold!
 
Back
Top