Filtering by a selected field

[Thurls]

Hi All,

I have a form with lots of fields and labels, I would like users to be able to double click on the field label to bring up a help box.

I have a table that has the fields label_name and help_memo, this information populates a form with the same fields. The form name is help_form

I also have code that opens the help_form form when a label in the main form is double clicked.

I'm looking for a way of filtering the records in the help_form form so that it only displays the information relating to the field that was double clicked on the main form. That would be when the label name double clicked equals the label_name field in the help_form.

Any ideas?

Sorry if this is confusing.

Thurls

 

[willir]

Two thoughts...

For the "On double click" event you can use the Open Argument option when opening up the Help form. For the [Event Procedure] use code to set the OpenArg value for each field before opening up the help form. The help form can test for the open argument and find the appropriate help record.

Or you can use the HelpContext ID feature in the property feild under the "Other" tab.

 

[Thurls]

Thanks Willir,

Is there a way of refering to the lable I've just double clicked on in the OpenArg without having to write the name of the field?

If my form has 40 labels I would like a generic open form code that I can use to open the help form when each label is double clicked. I would rather not have a different code statement for each double click event that refers to the name of the field I've double clicked on.

Thanks,

Cole

 

[PHV]

You may take a look at the ActiveControl and PreviousControl properties of the Screen object.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244