Pretty much. We don't care where you go but you can't stay here.
I hope you're able to work things out somehow. I know it's a bit tough right now. We at least still have our jobs, but my husband's company instituted a company wide 10% pay cut until probably October or so, so we're going to...
Where do you have the following code right now (what event)?
If Me!frmEquipmentSubform.Form!Name > "" Then
DoCmd.Close acForm, "frmEquipmentSubform"
Else
MsgBox ("Enter Name")
End If
Sometimes you have to play with it a little to get it into a format that Access likes. I would probably try putting it here:
If Me!frmEquipmentSubform.Form!Name > "" Then
DoCmd.Close acForm, "frmEquipmentSubform"
Else
MsgBox ("Enter Name")
DoCmd.CancelEvent
End If
Let me know if that works or...
I think you have to cancel the event (the exit command) that caused this to run. You might try adding in a DoCmd.CancelEvent to see if that stops the form from closing.
Don't know exactly what you're looking for, but if you're interested in straight VB.NET and not VBA then you might try looking here first. The MSDN site has all kinds of tutorials and other little gems hidden throughout.
Are you coding this in the main form then, and not the subform? If so, maybe you can try Me!frmEquipmentSub.Form!Name to see if that works.
Otherwise, here is a document that was posted ages ago by Mile-O that I still find useful:
My hubby likes to put a little brown sugar in his. I don't usually add any when making mine but I don't like sweet spaghetti sauces (although when just a little is used I can't tell a difference) and my stomach isn't sensitive so I don't have the problem some other people seem to have.