Any answers?

[Edwin Merced]

I have multiple Yes/No fields in a table. If a user chooses no, I would like
to have a corresponding table that assigns a diffrent no type statement to
each field. How would I do this? What must I do to link each no field with
the corresponding no statement? Please help THANX

 

[Arvin Meyer]

I have multiple Yes/No fields in a table. If a user chooses no, I would like
to have a corresponding table that assigns a diffrent no type statement to
each field. How would I do this? What must I do to link each no field with
the corresponding no statement? Please help THANX

More information would be helpful. How would one know which "no statement"
of assign?
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Edwin Merced]

Each no has only one "no" possibility (IT is a one to one correspondance for
each field

 

[Arvin Meyer]

I have to assume that you're speaking of the caption property, as there is
no "statement" property.

Depending upon how many there are, you could use the DLookup function to get
them from a table and set the caption property. DLookup is slow, so if you
have very many to do, you'll need a very fast machine and network.

If you are not talking about the caption property of a checkbox, please post
back a more complete description with specific details of what you are
trying to accomplish.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Edwin Merced]

No its not the caption property. Each no needs to be related to a unique
memo field whose content is a unique paragraph for each no.