Data Updates occurr automaticaly

  • Thread starter Thread starter jmawebco
  • Start date Start date
J

jmawebco

I have a form tied to an Access 2002 table. I would like to know if
there is a way for me to prevent data updates/additions from happening
until a submit button is clicked by the user. As it is now, as soon as
the form opens and the cursor moves from one field to another a record
is added to the table. I would appreciate any assistance anyone can
give me on this.

Thanks!!
 
This is one way, Im sure there are many others.
I ran upon this a while ago and this is what I did, there again, there is
probably a more effiecient ways of doing this.

What I did was to create a bunch of textboxes in the detail area, half with
a control source and the other half without no control source, then through
code from a command button I used code to cycle through the textboxes and
assign the unbound textboxes to the bound textboxes.
Watch your naming conventions for your textboxes, use like for example,
box1,box2,box3 for your bound controls, then use unbox1,unbox2,unbox3 for
your unbound controls so that you can cycle through the array easier.
You could try like this for code,

Dim i as Integer

' 1 to 10 stand for half of the textboxes used,change accordingly

For i = 1 To 10
Me("box" & i) = Me("unbox" &i)
Next i

David
 
Back
Top