Form_open & Form & Current Problems

[JayAndy]

Hi

I am trying to get a form to open a new record when its opens but the Form current is running after the open and is not opening a new record. just goes to the first record.

Here whats in the Current.

If Me!Listbox.Value = "Gym" Then
Me.Hours.Visible = True
Else
Me.Hours.Visible = False
End If

could this be stopping the DoCmd.GoToRecord , , acNewRec from working in the Open.

 

[bob fitz]

could this be stopping the DoCmd.GoToRecord , , acNewRec from working in the Open.

I don't think so. Have you checked that the code actually runs when the form opens

 

[JayAndy]

I don't think so. Have you checked that the actually runs when the form opens

Yeah have dchecked but goes straight to Current code after going through New record.

 

[bob fitz]

Yeah have dchecked but goes straight to Current code after going through New record.

Sorry but that's not clear to me. Does that mean yes the code runs or no it doesn't.