Fields not recognized

[Gord]

I have a simple form that is based on a query (AccessXP). I am using
using labels on the form to display text so that I am able to turn them (the
labels) on and off when certain conditions are met. Fields that were
entered into the table before the query was made are recognized in the
OnCurrent form code and work fine, but fields that I have later added to the
table and query are not recognized by VBA and as a result don't show up on
the labels.

Do I have to delete and rewrite the table to include the added fields be
able to use them?

Any help with this will be greatly appreciated.

 

[Mark A. Sam]

Gord,

No you don't need to delete the table and rewrite it. Try adding the fields
to the form. If you dont' want them to display, make them invisible on the
form by setting the visible propetyto False. IF that doesn't work try
refreshing your links if you are using linked tables.

It would help if you posted the code you are using.

God Bless,

Mark A. Sam

 

[Marshall Barton]

I have a simple form that is based on a query (AccessXP). I am using
using labels on the form to display text so that I am able to turn them (the
labels) on and off when certain conditions are met. Fields that were
entered into the table before the query was made are recognized in the
OnCurrent form code and work fine, but fields that I have later added to the
table and query are not recognized by VBA and as a result don't show up on
the labels.

Do I have to delete and rewrite the table to include the added fields be
able to use them?

No, you dont' have to delete and recreate anything.

Double check the query and make sure the query includes the
new fields in the table. If that doesn't help, then check
the form's RecordSource property to make sure it just
contains the query name, if it is another query or SQL
statement, fix that to include the new fields too.