SubForm On Current event detect New

[Middlemarch]

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 ?

[Bob Fitz]

In my datasheet subform I want to use the On Current event to choose an image to display.

Is the image going to be on the Main form?

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 ?

Know what is new?

[CJ_London]

Review
https://learn.microsoft.com/en-us/of...Form.NewRecord

[Middlemarch]

Sonds good CJ but I can't make it work.
In the SubForm Current event I put

MsgBox Me.Parent.NeWRecord

but it shows 0 regardless of new record or not.

Yes, Bob into an image control on the main form. (And the "what is new" is record.)

[CJ_London]

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

[Middlemarch]

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 ?

[CJ_London]

Really not prepared to waste my time trying to guess what you have and what you are actually trying to achieve.

[Bob Fitz]

Yes, Bob into an image control on the main form. (And the "what is new" is record.)

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.

[moke123]

Sorry, I don't know about subform linkchild/master or how to see if populated

Select the subform container and look in the property sheet.

[Middlemarch]

Really not prepared to waste my time trying to guess what you have and what you are actually trying to achieve.

If you can't understand my question then your replies are wasting my time too.

[CJ_London]

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