Can I modify a table and have those changes appear in the form co.

H

hcampbell

I am pretty much done designing my database, but a few things popped up that
I would like to add to a specific table, which I want to also show up in the
form connected to it? Do I need to re-do the form?
 
F

fredg

I am pretty much done designing my database, but a few things popped up that
I would like to add to a specific table, which I want to also show up in the
form connected to it? Do I need to re-do the form?

Not at all.
I guess you have tried to add the new fields and then can't find them
to add to the form.
I'll assume the record source of the form is a query (or SQL
statement).
First, add the new fields to the table.
Then add the new fields to the query (in query design view) that is
the form's record source.
Then, in form design view, add the fields to the form from the field
list tool button.
 

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