Add new control source - new field not showing in query (1 Viewer)

emk1240

New member
Local time
Today, 10:28
Joined
Jul 31, 2020
Messages
1
Hi all,

I need to add a new control source for a new checkbox I have in a table. When I run a query to add it, the field isn't showing up and I can't add a control source, rendering my checkbox useless. Any ideas on a fix?

(edit: I've also refreshed the table with linked table manager, didn't do anything)
 

bob fitz

AWF VIP
Local time
Today, 15:28
Joined
May 23, 2011
Messages
3,972
Hi all,

I need to add a new control source for a new checkbox I have in a table. When I run a query to add it, the field isn't showing up and I can't add a control source, rendering my checkbox useless. Any ideas on a fix?

(edit: I've also refreshed the table with linked table manager, didn't do anything)
I don't understand. Tables do not have checkboxes. Checkboxes are a control that can be used on a form but I would not use a query to change the Control Source of a checkbox. I would use VBA code.
 

Isaac

Well-known member
Local time
Today, 07:28
Joined
Mar 14, 2017
Messages
1,513
@emk1240
Did you "remove" the table from query design, and then re-'add' it?
The query won't automatically refresh showing that field from the table. You have to right click on the table, Remove, Re-add, and then it will show up.
 
Last edited:

The_Doc_Man

Immoderate Moderator, Former MVP, Retired SysAdmin
Staff member
Local time
Today, 09:28
Joined
Feb 28, 2001
Messages
17,334
The context of your statement is ambiguous.

I THINK you are telling us that you added a checkbox (actually, a Yes/No field) to a table but it is not showing up in other places that use that table. That is because you have to go back to update those usages, whatever they are, to include the new field. Inclusion of new fields is NOT automatic, i.e. you don't get a "ripple down" because you added a field to something upstream from the place in question. (And that works the other way, too, because removal from the source doesn't propagate to the places of use - though an error indicator WILL show up.)

You said you can't add a control source. Which makes me think that we don't understand something about your environment. WHY can't you add a control source (or at least edit one)?
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom