table not getting updated

  • Thread starter Thread starter kkruz
  • Start date Start date
K

kkruz

I have a form with info derived from a query. It opens from another form
with default data in some of the fields.
While trying to save information programmably, i can not get this to happen.
The only time that I can get the info to update in a table is when I
actually change one of the default values.

Can anyone help we determine a method to use to force the action of data
moving to the table?

thanks
 
kkruz said:
I have a form with info derived from a query. It opens from another
form with default data in some of the fields.
While trying to save information programmably, i can not get this to
happen. The only time that I can get the info to update in a table is
when I actually change one of the default values.

Can anyone help we determine a method to use to force the action of
data moving to the table?

thanks
Click to expand...

In 99.999% of cases one would not want a record to actually be created just from
default values so that is not how it works. In fact there actually is no record
created and thus no record to save until at least one value is set either
manually or programmatically. Just set one of those controls with a default
value equal to itself and that will dirty the form allowing you to save it.
 
KKruz said:
Is there any other way to dirty the form programmatically?
Click to expand...

You have to set a bound control equal to something. I assume that the only
controls that you already know what the value should be are the ones where you
have set a Default Value.

Really if you are opening a form only to immediately save the record without
adding or changing anything then you don't need the form at all. Forms are
tools for *users* to interact with the data. If you can do it all without the
user being involved then just use an INSERT or UPDATE query and skip the form
altogether.
 
Back
Top