add record from a form to a table

[dee230783]

Hi all
i use access 2007 to make form..But my problem is if i add a new record from the form..its not connected with the table...it means that data that i add in form didnt insert in form automatically.....How to make data that i add in form also add to table too????????

[copleyuk]

The easiest way with 2007 is to select the table that you want to create a form for on the navigation panel then select "create" from the options at the top of access window and then click on "form".

This will automatically generate a form based on the content of that table and allow you to add data to the table through that form.

If you want to continue using your form then you need to make sure that each text box etc is bound to the correct item within you table.

When you look at the form in design view are the text boxes on your form called unbound or are they named after the columns of your table?

[dee230783]

@copleyuk
yeah i make form by clicking create form button n the text box is bound to the table...but when i fill a new record in the form...n i save. My table dont make any progress, it still contain the same record like before i fill new record in the form.....
Help me plzzz

[copleyuk]

@dee230783
You said "when I save" are you using a save button which has been added by you?

Can you upload a copy of the form and or table?

[dee230783]

@copleyuk
i do with the button add record but it doesnt work..n i do with save form it doesnt work too
link:

http://www.4shared.com/file/CCTfAl5X/form_table.html

u can see that in form their 9 records but in table still 6 records

[copleyuk]

@dee230783
If you select refresh all with the table open does this show the other 3 records??

[Jerry Maiapu]

This is strange. If the form or its objects are bound to a table that I do not see why the data entered on the bound form object do not get into the table.

Ok there's something wrong somewhere. Let me ask you this.

Does the record source (table) share a relationship with another table? if so then what kind?

Tables sharing 1:1 relationship poses similar problems.

Also try resetting the control source of the form.
Having a one to one relaionship sometimes causes this.

[dee230783]

@Jerry Maiapu
thats only one table so it dont relate with another table..So i guess its not necessary to do relationship..
Yah its weird condition n make me got headache.
If i do refesh...the table don't change tooo..........
Pleaseeeeeeeeeee help me

[Jerry Maiapu]

Ok, I am sorry about this but We'll try and use VBA to insert the data on the form straight into table and see if it is working. Give all the names of the txt boxes on the form and the corresponding fields in the table and the table name.