G Guest Sep 9, 2005 #1 What is the code for incrementing an integer field in a table by pushing a button on a form? I'm drawing a blank. thanks in advance
What is the code for incrementing an integer field in a table by pushing a button on a form? I'm drawing a blank. thanks in advance
A Alex Dybenko Sep 10, 2005 #2 Hi, i think easiest way is to use an update query: currentdb.execute "Update MyTable Set MyField=MyField+1 Where ID=" & me.ID, dbfailonerror
Hi, i think easiest way is to use an update query: currentdb.execute "Update MyTable Set MyField=MyField+1 Where ID=" & me.ID, dbfailonerror
