the code should go OnLoad...
remember, the conditions are such that you only see aReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10434Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10434
message if MORE than one record is returned...
try this for testing...
Private Sub Form_Load()
If Me.Recordset.RecordCount > 1 Then
MsgBox Me.Recordset.RecordCount _
& " records were returned" _
, , "RecordCount"
MsgBox "one record was returned" _
, , "One record"
Microsoft Access MVP 2006
Have an awesome day
remote programming and training
strive4peace2006 at yahoo.com
> I tried attaching this bit of code to the OnOpen event and also to the
> OnLoad event of the form and neither worked ???