No such field

[Guest]

I am new to Access. We have a subform that has one field from one control
source. All other fields on this subform are located within a different
control source. How do I fix without removing any of the required fields?

 

[John Vinson]

I am new to Access. We have a subform that has one field from one control
source. All other fields on this subform are located within a different
control source. How do I fix without removing any of the required fields?

Please rephrase your question; as such it makes no sense. A given
Control (textbox, checkbox, combo, whatever) on a Form has a Control
Source, the name of the field to which it is bound, or an expression
which calculates the value to be displayed. The sentence "all other
fields on this subform are located within a different control source"
simply makes no sense.

What is the Recordsource of the subform? Please post the SQL.
What is the Control Source of this control?
What are you trying to accomplish?

John W. Vinson[MVP]