Forcing sub form data

[OptimisticYid]

I have a main form, lets call it orders and a subform, lets call it order activity How can I force the user to enter in an activity before they exit the main form ....?

Thanks in advance

 

[gemma-the-husky]

are you sure you can see everything on the from - its not just the screen resolution hiding the top row of tabs is it? - can you stretch the form to make the tab headers visible?

 

[OptimisticYid]

Sorry Gemma don't quite understand where you are coming from. The form works perfectly, I just want to set it so that a related record in the activity log HAS to be created before the main form can be exited.

 

[OptimisticYid]

Sorry to bump but I could really do with a solution ....... pwetty pwease

 

[georgedwilkinson]

I'm not sure I understand this thread, but going back to the original post, you should experiment with some of the events of the form, like "On Lost Focus", "On Deactivate", etc.

I don't know what they all do, but I would experiment with each and MsgBox. Then write VBA code accordingly.