save records from forms in tables

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?
 
D

Dennis

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.
 
S

Smoki

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!
 
S

Smoki

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top