how to save a record

K

Kon

I want to save a record in a form without going to previous or next record.
I have a button wich says save and when
the user clicks save to save the record. I tried docmd.save but nothing
happened. the me.refresh, me.requery but nothing again.
Besides this, which is the best solution to use for a combo box to requery.
Which event. for example I have
customers tables and when I enter a new one and switch form where the combo
box is which event to use to requery. The combobox is bases on an sql
statement. I tried on get focus, on enter but nothing happened.

Thanks in advance.
 
R

Rick Brandt

Kon said:
I want to save a record in a form without going to previous or next
record. I have a button wich says save and when
the user clicks save to save the record. I tried docmd.save but
nothing happened. the me.refresh, me.requery but nothing again.
Click to expand...

Me.Dirty = False

DoCmd.Save is actually for saving design changes to the form, not data.
Besides this, which is the best solution to use for a combo box to
requery. Which event. for example I have
customers tables and when I enter a new one and switch form where the
combo box is which event to use to requery. The combobox is bases on
an sql statement. I tried on get focus, on enter but nothing happened.
Click to expand...

Both of those should be fine. Did you make sure to save the new record before
you issued the Requery?
 
Top