OPENING & LINKING FORMS

[SteveD]

Hi People,

I've created a number of forms on my database where users select items from a combo box, then if they wish they can view more detailed records by pressing a command button. The command button uses the Me! property of the combo box to show related records. My problem is that if there are no related records, a blank form is opened. Can anybody tell me a simple way for a message box to appear saying 'no related records' instead of a blank screen.
I'm fairly new to this sort of thing, so if you could make it as simple as possible it would be appreciated!

Thanks in advance,

Frustrated Access user in London.

 

[Rich]

Look for help on RecordsetClone.RecordCount properties or If IsNull(Me.Textbox)on the Load Events for your forms.
HTH