Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access forms and tables

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access forms and tables

Access forms and tables

ResolvedVersion 2003

Helen has attended:
Access Introduction course

Access forms and tables

When I have an existing table and linked form, can I amend the form (i.e. add a new field/ combo box etc) to add information to the existing table? Or do I have to create a whole new table and form?

RE: Access forms and tables

You don't need to create a new table. Open the existing table in design view and add the field at the bottom of the list of fields and save the table and close it.

If you used Autoform to create your form you could repeat that, or you could open your existing form in design mode and drag the new field from the field list onto your form.

Does that solve your problem?

Laura

Access tip:

Action queries

Unlike select queries you cannot use action queries as a data source for the use with forms or reports,as they do not return a dataset that can be read.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.