In my datasheet subform I want to use the On Current event to choose an image to display.
When the mainform moves to a new record, can the Subform know this is New - as opposed to a click on a subsequent record in the subform ?
In my datasheet subform I want to use the On Current event to choose an image to display.
When the mainform moves to a new record, can the Subform know this is New - as opposed to a click on a subsequent record in the subform ?
Is the image going to be on the Main form?
Know what is new?
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
Sonds good CJ but I can't make it work.
In the SubForm Current event I put
but it shows 0 regardless of new record or not.Code:MsgBox Me.Parent.NeWRecord
Yes, Bob into an image control on the main form. (And the "what is new" is record.)
think you need to show what you are trying to do.
Are the subform linkchild/master properties populated?
Since the 'event' that takes you to a new record is in the main form, the code needs to be in the main form
Sorry, I don't know about subform linkchild/master or how to see if populated
Yes, perhaps if I knew where the 'event' is I could set a global variable that the subForm current event could read.
This could be when you the navigation bar? (Record selector??) button. Does that raise an event you can put code in ?
Really not prepared to waste my time trying to guess what you have and what you are actually trying to achieve.
Well that much I realised, but a new record on which form: Main or Sub?
The attached db may help with your understanding of the OnCurrent event.
I agree with Chris that we can't be of much help i you don't give us much information. I would suggest that you tell us exactly what you are trying to do and post a copy of your db.
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
not a problem for me -you are the one needing help and saved yourself time by not bothering to show what you are trying to. I'll put you on my ignore list, then everyone is happy