I added a new field to an existing table but when I go to add that field to
an existing form using field list it isn't an option.

Pat wrote:
> I added a new field to an existing table but when I go to add that
> field to an existing form using field list it isn't an option.

Is the form based on the table or maybe a query?

--
Joseph Meehan

Dia 's Muire duit

It has every field in the table except the new one so I assumed it was based
on the table. How do I determine what the form is based on?

"Joseph Meehan" wrote:

> Pat wrote:
> > I added a new field to an existing table but when I go to add that
> > field to an existing form using field list it isn't an option.
>
> Is the form based on the table or maybe a query?
>
> --
> Joseph Meehan
>
> Dia 's Muire duit
>
>
>
>

If the form's based on a query, as it really should be, you need to go into
Design View for the query and add the new field to the grid.

Joseph Meehan wrote:
>> I added a new field to an existing table but when I go to add that
>> field to an existing form using field list it isn't an option.
>
> Is the form based on the table or maybe a query?
>

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via http://www.accessmonster.com

Look at the form's Record Source property in the Properties dialog box. If
it looks like SQL, rather than a table name, click on the ellipsis (...) to
the right of the property.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Pat" <(E-Mail Removed)> wrote in message
news:3085CA02-D9BB-4B91-98A7-(E-Mail Removed)...
> It has every field in the table except the new one so I assumed it was
> based
> on the table. How do I determine what the form is based on?
>
> "Joseph Meehan" wrote:
>
>> Pat wrote:
>> > I added a new field to an existing table but when I go to add that
>> > field to an existing form using field list it isn't an option.
>>
>> Is the form based on the table or maybe a query?
>>
>> --
>> Joseph Meehan
>>
>> Dia 's Muire duit
>>
>>
>>
>>

Is there a properties or something for the form that I can find which Query
is it based on?

"missinglinq via AccessMonster.com" wrote:

> If the form's based on a query, as it really should be, you need to go into
> Design View for the query and add the new field to the grid.
>
> Joseph Meehan wrote:
> >> I added a new field to an existing table but when I go to add that
> >> field to an existing form using field list it isn't an option.
> >
> > Is the form based on the table or maybe a query?
> >
>
> --
> There's ALWAYS more than one way to skin a cat!
>
> Answers/posts based on Access 2000
>
> Message posted via http://www.accessmonster.com
>
>

Douglas You are my MVP Thanks so much that is exactly the info I needed
"Douglas J. Steele" wrote:

> Look at the form's Record Source property in the Properties dialog box. If
> it looks like SQL, rather than a table name, click on the ellipsis (...) to
> the right of the property.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "Pat" <(E-Mail Removed)> wrote in message
> news:3085CA02-D9BB-4B91-98A7-(E-Mail Removed)...
> > It has every field in the table except the new one so I assumed it was
> > based
> > on the table. How do I determine what the form is based on?
> >
> > "Joseph Meehan" wrote:
> >
> >> Pat wrote:
> >> > I added a new field to an existing table but when I go to add that
> >> > field to an existing form using field list it isn't an option.
> >>
> >> Is the form based on the table or maybe a query?
> >>
> >> --
> >> Joseph Meehan
> >>
> >> Dia 's Muire duit
> >>
> >>
> >>
> >>
>
>
>