Troubles with control sourrce for a text box

  • Thread starter Thread starter CristianTCDM
  • Start date Start date
C

CristianTCDM

Hello evrybody,

I am trying to set the control source of an unbound textbox on a form . I
used the following syntax :

=[RPfeedbackPART1]![Med]

The result is only # Name ?.
RPfeedbackPART1 is a Query and Med is one of his fields .

Thanks for any idea
 
Hello evrybody,

I am trying to set the control source of an unbound textbox on a form . I
used the following syntax :

=[RPfeedbackPART1]![Med]

The result is only # Name ?.
RPfeedbackPART1 is a Query and Med is one of his fields .

Thanks for any idea
Click to expand...

You can't refer to queries in this way. What is RPfeedbackPART1? Does it
contain only one record, or do you have some way to determine which record
should be displayed based on the other contents of the form?

If it's a single-record query then you can use

=DLookUp("[Med]", "[RPfeedbackPart1]")

as the recordsource. If not... more info needed!
 
Yes , it is a single row query .

I tried your sugestion with DLookup function and it works .

Thank you very much !

John W. Vinson said:
Hello evrybody,

I am trying to set the control source of an unbound textbox on a form . I
used the following syntax :

=[RPfeedbackPART1]![Med]

The result is only # Name ?.
RPfeedbackPART1 is a Query and Med is one of his fields .

Thanks for any idea
Click to expand...

You can't refer to queries in this way. What is RPfeedbackPART1? Does it
contain only one record, or do you have some way to determine which record
should be displayed based on the other contents of the form?

If it's a single-record query then you can use

=DLookUp("[Med]", "[RPfeedbackPart1]")

as the recordsource. If not... more info needed!
Click to expand...
 
Back
Top