Can anyone tell me how I can get the current record number when any field is clicked in the detail section of a continuous form? I can get the value by using the "Click" option for each of the fields but I was wondering if there is an option I can use that is easier. I tried using the "On Click" option for the detail section but it only works when I click between the fields and not when I click on the fields.
Have you considered including the record number in the Underlying Query that supplies the data, it will then be visible all the time?
Than you for the reply. My question is more of getting VBA activated to run the same code if any text box is "clicked" in the detail section.Originally Posted by OBP
The only way I know of is to have the code in each Field's On Click or on Focus events.
You can have generic code in there to run code in a module, but it still needs the activatuion in each field.
That is what I thought. Would be nice to have that option available.
Which option?
The Form's On click event would probably do what you want, but it would display the record number whatever the user clicked, ie a close button or any other object.
Posting Permissions
Reply With Quote
