Checking a subform for data

[Junior]

I have a form [Frm1] with a subform [sfrm1]
Parent-child linked by AppID
sfrm1 is datasheet view and used to select multple items-
ie. enter data that is stored in tblItems
AppID, ItemID, Description
When Frm1 closes, how can i check if any data has has been entered using the
subform.
Basically, i want to display a msgbox if Frm 1 closes and no data has been
entered in sfrm1.
Thanks

 

[Rick]

I would add a field to my main form and default the value to false.

I would add an event procedure to my subform in the "AfterInsert" event to
update the field on my main form with a value or true.

In the OnClose event of my main form, I'd ceck the value of that field.

I'm sure there are several other options available.

Rick

 

[Rick]

Note that the new field does not need to be visable.

I would add a field to my main form and default the value to false.

I would add an event procedure to my subform in the "AfterInsert" event to
update the field on my main form with a value or true.

In the OnClose event of my main form, I'd ceck the value of that field.

I'm sure there are several other options available.

Rick

I have a form [Frm1] with a subform [sfrm1]
Parent-child linked by AppID
sfrm1 is datasheet view and used to select multple items-
ie. enter data that is stored in tblItems
AppID, ItemID, Description
When Frm1 closes, how can i check if any data has has been entered using the
subform.
Basically, i want to display a msgbox if Frm 1 closes and no data has been
entered in sfrm1.
Thanks

 

[Junior]

Rick - i'll try your idea - thanks

I would add a field to my main form and default the value to false.

I would add an event procedure to my subform in the "AfterInsert" event to
update the field on my main form with a value or true.

In the OnClose event of my main form, I'd ceck the value of that field.

I'm sure there are several other options available.

Rick

I have a form [Frm1] with a subform [sfrm1]
Parent-child linked by AppID
sfrm1 is datasheet view and used to select multple items-
ie. enter data that is stored in tblItems
AppID, ItemID, Description
When Frm1 closes, how can i check if any data has has been entered using the
subform.
Basically, i want to display a msgbox if Frm 1 closes and no data has been
entered in sfrm1.
Thanks