save records from forms in tables

  • Thread starter Thread starter Smoki
  • Start date Start date
S

Smoki

Hy, I have a problem with my form and saving records from forms in my table!
I have the same fields in tables, like in form and when I fill this fields
and enter command button Save on my form, it doesn't appear in my table.
How to connect my form with tables?
 
You either need to write code behind your command button to write the data
from the boxes on your form into your table, or make sure the control source
property of the form is set to your table name in which case the data will go
into your table without the need of a save button.
 
Control source was not set good, but I made it OK now, and it works. Thank you.
I have other qestion now: when I enter data in form and save this in table,
I want to open form to enter new data in fields, but I always open form with
my old data, and this fields are not blank. What to do? I tried with command
button Save record, after that Add new record, but I didn't get what I wanted!
 
Thanks!
More questions? I think I made some mistake at the beggining. I'm filling
fields, and I can save this records in table, but wneh I close my form, and
open it again, every time I see my first record, fields are not blank.
Where is the problem?
 
Back
Top