Hi I want to create a form that if a tick box is ticked then it will show one type of data and if not show the other.

i.e. if an agent is currently being used and the tick box 'show current' is ticked then it will show the data.

There is a field in the table of where the data resides that sais agentcurrent Yes/No. Can anyone help?

In the forms On Current event:

If Me.TickBoxName = -1 Then
Me.AgentField.Visible = True
Else
Me.AgentField.Visible = False
End If