How do I save data from a table to an existing form?

[Guest]

I am a new user to Access. I have created a table and used wizard to create
a form for this table. I have deleted some rows from the table and now I am
trying to figure out how I update my form with the changes I made to my table.

 

[Douglas J. Steele]

Um, forms are strictly windows into tables. They don't have any values of
their own: the values they have come from the tables. Any deletes in your
table should automatically result in that data not being shown in the form
anymore.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

I am a new user to Access. I have created a table and used wizard to create
a form for this table. I have deleted some rows from the table and now I am
trying to figure out how I update my form with the changes I made to my

table.

 

[AlCamp]

Michael,
You don't. The RecordSource for the form IS a table or a query (let's
say a table in this case). Datasheet view is a way to display the contents
of a table, and using a "form" view is exactly the same. If your table
contains 10 records, then you can "browse" (look at) record 1 to record 10
using a form. If you delete 2 records from your table via a datasheet view,
then the datasheet and the form will only display the 8 records that are
left.
The form is only a "different" way to look at (and operate on) the data
in a table.
As long as the form is "bound" to the table, any changes you make to the
contents of that table will show the same results in form view or datasaheet
view.
hth
Al Camp

I am a new user to Access. I have created a table and used wizard to create
a form for this table. I have deleted some rows from the table and now I am
trying to figure out how I update my form with the changes I made to my

table.

 

[Matt Lusher \(MSFT\)]

If the other replies understood your question correctly, you can ignore this
response. However, I'm going to assume that when you're talking about rows
in the table, you're talking about rows in the Table Design view. Here, rows
actually represent columns, i.e. fields, which map to fields in your form.
Therefore, while it's true that if you delete data from a table (which shows
up as rows in "spreadsheet" view), you don't need to do anything to the
form, if on the other hand you deleted rows from the Table Design view, then
you do need to make changes.

If I understand your problem correctly, then, you've got a couple of ways to
change your form's design to match the design changes you made to the table.

The first option is to open your existing form in Design view; you can do
this in your database window by selecting the form and click Design in the
database window toolbar, or by right-clicking the form and selecting Design
View. Either way, the Design window opens up, and you can select and delete
the fields on the form that correspond to the table elements you deleted
earlier.(You can also do a lot more here; it's a complete toolset for
customizing your form's appearance and behavior.)

The second option, which is simpler if you're happy with the results, is to
use the form wizard again the same way you did the first time, and let it
make a new form from the table. You can then delete the old form and rename
your new one to match the old.

--
Matt Lusher
Microsoft Corporation
Disclaimer: This posting is provided "AS IS" with no warranties, and confers
no rights.

I am a new user to Access. I have created a table and used wizard to create
a form for this table. I have deleted some rows from the table and now I am
trying to figure out how I update my form with the changes I made to my

table.