How to link textbox data in a form to data in a table

[jimbob90]

dahsdjahskjdhaskdhaksda

[June7]

Have you bound the form and data controls? In other words, set RecordSource and ControlSource properties?

Since you did attach the db and not just a screenshot, I have found answer to the above question. No, you have not bound the form and its controls. Bound form and controls are linked to table. All data entry/edits will pass direct to the table fields.

Since there is no connection to the table, the macro to save record accomplishes nothing.

Record entry/edit is committed to table from bound form/controls when the form closes or loses focus, move to another record, or run code.

[jimbob90]

jdhaskjdhkasjhdkashdkahskda

[June7]

Set the RecordSource property of form. Set the ControlSource property of data controls.

[jimbob90]

what do i set them to???/

[jimbob90]

would you mind looking through my access file for me?

[June7]

I did look through your file, that is how I discovered the form is not bound.

Form in design view, open the Property window.

Make sure form is selected. The form RecordSource must be a table, a query, or an SQL statement. Click the dropdown and select a table or query.

Select a control. ControlSource must be a field of the form's RecordSource. Once the form is bound, the ControlSource dropdown will show a list of available fields.

This is very basic Access functionality. Access Help has guidelines on building form.

Also http://databases.about.com/od/tutori...s2007forms.htm

[jimbob90]

52571823812u3woijhkwjhdska

[June7]

I would rather you build the form correctly yourself. As stated, this is VERY basic Access and you must understand this before continuing. Best way to learn is by doing. Did you select Rentals as the RecordSource and set each ControlSource to a field of Rentals? Then you have done what I would do.

What do you mean by 'had data in the fields which i can not change'? This form when bound will display all existing records. If you want to enter a new record, must navigate to a new (blank) record. Can use the intrinsic navigation bar at bottom of the form to do that.

[jimbob90]

00000000000000000000000000000000000000000000000000 00000000000000000

[jimbob90]

skhdakjshdkjashdkajs

[June7]

From post #2: Record entry/edit is committed to table from bound form/controls when the form closes or loses focus, move to another record, or run code.

[jimbob90]

wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww

[jimbob90]

jhksdhdkajshdkjahksd

[June7]

You now have the form and its controls bound. Closing the form or moving to another record will commit the record entry/edit to table. I notice that form losing focus is not committing the record as I thought it would.

The record save button isn't working because there is no associated code. I thought it was an embedded macro in the first version. Now it is a VBA [Event Procedure]. However, there is no code in the procedure. Need: DoCmd.RunCommand acCmdSaveRecord

Review:
http://office.microsoft.com/en-us/ac...010341717.aspx
http://www.access-vba.net/introducti...ccess-vba.html

BTW, I deleted your new thread that duplicates this topic.