[WB24]COMBO Linkted to Query

Good day

If I have a combo linked to a query, how do I access other fields in that query when an item is selected from the combo.

I update the linked file ID with the ID from the query, but I want to look at start and end dates within the query to determine if the selected item is valid.

Thanks in advance


Ericus Steyn

Hi Ericus,

You can do a hReadSeekfirst on the id of the query in the "Whenever modified" code of the combo and then get the date fields.

Kind regards,
Piet

Greeting

In the combo box, it uses the Table option and you can add the fields you need here

[infosonline.net]