Combo Box

C

Chester1

I have created a combo box to find data based on what I choose in the combo
box this works fine. But when I go into the form the combo box field is
empty but all the other fields have information in them the combo box works
as when I select something from it the other fields fill with the relevant
information. What I want is to be able to go in to the Form and for all
fields to be blank until I select something form the combo.
 
A

Anne

Private Sub Form_Open(Cancel As Integer)
DoCmd.GoToRecord , , acNewRec
Me![Comboboxname] = Null
End Sub
 
C

Chester1

Anne

That worked a treat Many Thanks.
--
Regards Clair


Anne said:
Private Sub Form_Open(Cancel As Integer)
DoCmd.GoToRecord , , acNewRec
Me![Comboboxname] = Null
End Sub


Chester1 said:
I have created a combo box to find data based on what I choose in the combo
box this works fine. But when I go into the form the combo box field is
empty but all the other fields have information in them the combo box works
as when I select something from it the other fields fill with the relevant
information. What I want is to be able to go in to the Form and for all
fields to be blank until I select something form the combo.
 
Top