I actually have 3 questions that I am hoping someone can help me with.
1. On a form I want fields to be invisible until one field meets its requirements and then the rest become visible. I have the following code in but its not working.
Private Sub Act1Cal_AfterUpdate()
Me.CalisthenicsDone.Visible = False
If Me.Act1Cal = "Calisthenics" Then
Me.CalisthenicsDone.Visible = True
End If
End Sub
2. I want to know if it is possible to have a table to only allow 10 records? If it is possible how to I do that.
3. I have been playing with the database I am creating and as I work with it I am creating records that have an autonumber. Is there away to reset the autonumber back to 1?
Any help would be much appreciated,
Brad.