|
 |
access thread: report text field
Message #1 by "Nikola" <Nikola@B...> on Tue, 16 Jul 2002 21:23:27 +0300
|
|
Hi,
how to create text field in report with value of second column of combobox?
I know if in control source I put :
=[Forms]![NextCall]![cmbPortID] in report is gone show value of combo, in
this case PortID what is number but second column is name of port and I want
in field of report to show me name. I was try :
=[Forms]![NextCall]![cmbPortID.column(1)] but is not working. Any idea?
And let say I have 10 record display in report .How to mark each record with
number?Samething like this:
1. (first record)
2. (second rec.) and etc,ect.
Thanks
Message #2 by "Nikola" <Nikola@B...> on Tue, 16 Jul 2002 21:28:26 +0300
|
|
I found mistake in control source:
=[Forms]![NextCall]![cmbPortID].[Column](1)
-----Original Message-----
From: Nikola [mailto:Nikola@B...]
Sent: Tuesday, July 16, 2002 9:23 PM
To: Access
Subject: [access] report text field
Hi,
how to create text field in report with value of second column of combobox?
I know if in control source I put :
=[Forms]![NextCall]![cmbPortID] in report is gone show value of combo, in
this case PortID what is number but second column is name of port and I want
in field of report to show me name. I was try :
=[Forms]![NextCall]![cmbPortID.column(1)] but is not working. Any idea?
And let say I have 10 record display in report .How to mark each record with
number?Samething like this:
1. (first record)
2. (second rec.) and etc,ect.
Thanks
|
|
|
View Cart
