Combo Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Private Sub Form_Open(Cancel As Integer)
DoCmd.GoToRecord , , acNewRec
Me![Comboboxname] = Null
End Sub
 
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.
Click to expand...
Click to expand...
 
Back
Top