Form Property SelectionChange

[MarionD]

Hi there,

Can anyone tell me when the Form Property "selectionchange" kicks in?

I am trying to use this to run an event procedure.
I have a sub form datasheet which contains a date, and when the selection is changed from one record to another in the sub form, I would like to run an event procedure that updates certain fields on the main form, according to the date.
I have put msgbox in the event procedure, but it doesn't trigger when the selection is changed? or am I misunderstanding the property?
I have also tried got focus, lostfocus, beforeupdate, but they only trigger when the record is changed, not just when the selection is changed.

Thanks
Marion
:banghead:

 

[spikepl]

This type of questions you can resolve yourself by:

1. Look the event up in the documentation
2. Place the cursor in the Properties->Events->On Selection Change field and either press F1-button or read what it says in the status line (the lower edge of the Access window)

 

[MarionD]

Thanks, been there done that! Still can't get it to work.
If I read the documentation, I understand that if the selection is changed it should trigger an event procedure, but it doesn't. As I said I have put message boxes in the event procedure to check, but they event procedure is not called at all by changing the selection in the form.
Marion

 

[spikepl]

Well , instead of assuming a lot, try reading the docs again, they actually say very specifically what triggers the event. And so does the text in the status bar.

 

[MarionD]

Thank you for the reply. However, I would prefer no answer than a sarcastic one. It is quite intimidating for mere mortals like myself. If the question irritates you, then don't answer it.

Marion