Geoff Codd
Registered User.
- Local time
- Today, 05:06
- Joined
- Mar 6, 2002
- Messages
- 190
I've got the following code that I can't get to work
If Me.NewRecord Then
Me!AddOrder.Visible = False
Me!PreviousRecord.Visible = False
Me!NextRecord.Visible = False
ElseIf Me.RecordCount = 1 Then
Me!AddOrder.Visible = True
Me!PreviousRecord.Visible = False
Me!NextRecord.Visible = False
Else
Me!AddOrder.Visible = True
Me!PreviousRecord.Visible = True
Me!NextRecord.Visible = True
End If
If It's a new record it hides buttons
if there is a record count of 1 then you can add
if there is more than one record you can add and navigate
Someone please help with what probably is something vey simple
Thanks
Geoff
If Me.NewRecord Then
Me!AddOrder.Visible = False
Me!PreviousRecord.Visible = False
Me!NextRecord.Visible = False
ElseIf Me.RecordCount = 1 Then
Me!AddOrder.Visible = True
Me!PreviousRecord.Visible = False
Me!NextRecord.Visible = False
Else
Me!AddOrder.Visible = True
Me!PreviousRecord.Visible = True
Me!NextRecord.Visible = True
End If
If It's a new record it hides buttons
if there is a record count of 1 then you can add
if there is more than one record you can add and navigate
Someone please help with what probably is something vey simple
Thanks
Geoff