Fields not recognized

  • Thread starter Thread starter Gord
  • Start date Start date
G

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.
 
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
 
Gord said:
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?
Click to expand...

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.
 
Back
Top