Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I reference a column's value in a listbox? 1

Status
Not open for further replies.

rleiman

Programmer
May 3, 2006
258
US
Hi Everyone,

In a form procedure I have a listbox called Browse:LayawayPayments. One of the columns inside that listbox is from the table column LAYPAY:paymentDate. In the accepted event of my ?LAY:TotalSales I would like to get the value of LAYPAY:paymentDate. Can you tell me the syntax to do this?

I already tried this without luck. Am I close?
message(?Browse:LayawayPayments.PaymentDate)

Thanks.

Emad
 
Hi Emad,

The browse's ListBox is fed by a Queue. So to get the current entry, you do the following:

Assuming Queue:LayawayPayments to be the Queue used in the Browse :

GET(Queue:LayawayPayments, CHOICE(?Browse::LayawayPayments))

MESSAGE(Queue:LayawayPayments.LAYPAY:paymentDate)

Regards
 
Hi ShankarJ,

Thanks for the helpfull answer. I will use it.

Truly,
Emad
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top