Added new field to access table, but vb cannot refer to it

[oldtimer99]

VB program (access) use to schedule students for career day. Added check box for 6 grade (already has 1-5). VB does not allow use of it. Not in object list. How do I add it to list so it can be used in pgm. I am network engineer and lost.

 

[SkipVought]

hi,

Added check box for 6 grade (already has 1-5).

Your problem is your DESIGN. If you need to add fields in order to accomodate new data, your design is not NORMALIZED. I'm no expert in db design, that that is 101 basics.

You migh try posting in an Access forum, like forum700, forum702 or forum705.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[oldtimer99]

Thank You, I will follow your advise. By the way I did not design the DB. I just been attempting to use it for the last few years.