Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Sep 2002
    Posts
    81
    Thanks
    0
    Thanked 0 Times in 0 Posts

    blank form (Access 2000)

    My form consists of combo boxes for choosing different names.However after i have finished with the operation and open the form again,it shows those names in the combo boxes,that i have chosen last time.How can i clear my form so that the combo box are blank ?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: blank form (Access 2000)

    Are the combo boxes bound to a field in the record source of the form? If so, selecting a name in the combo box will store that name in the bound field.

    If you don't need to store the values in a table, you should make the combo boxes unbound, i.e. clear their Control Source property.

    If you do need the values to be stored, you can open the form to a new (blank) record:

    Private Sub Form_Load()
    RunCommand acCmdRecordsGoToNew
    End Sub

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •