Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Posts
    4

    Unanswered: I want Combo Box to pull up Blank

    I have a form on which I have put a Comb-Box with a drop-down field list that either says Yes or No. I have the combo Box set up in my main Table (Emp Data Table) as a combo Box with the dropdown box. On the form I set the control source of the combo Box to feed from that field of the Emp Table. All I want to do is to make it that the box is blank until I actually select the Yes or No answer. How can I do this?


    Thanks!

    Shiloh

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Question Re: I want Combo Box to pull up Blank

    Originally posted by Shiloh917
    I have a form on which I have put a Comb-Box with a drop-down field list that either says Yes or No. I have the combo Box set up in my main Table (Emp Data Table) as a combo Box with the dropdown box. On the form I set the control source of the combo Box to feed from that field of the Emp Table. All I want to do is to make it that the box is blank until I actually select the Yes or No answer. How can I do this?


    Thanks!

    Shiloh
    As long you didn't set its value, it will still blank

    You can set it like that
    Me.combo= "your set value"

  3. #3
    Join Date
    Dec 2003
    Location
    Belgium
    Posts
    42

    Re: I want Combo Box to pull up Blank

    Originally posted by Shiloh917
    I have a form on which I have put a Comb-Box with a drop-down field list that either says Yes or No. I have the combo Box set up in my main Table (Emp Data Table) as a combo Box with the dropdown box. On the form I set the control source of the combo Box to feed from that field of the Emp Table. All I want to do is to make it that the box is blank until I actually select the Yes or No answer. How can I do this?


    Thanks!

    Shiloh
    You could use the code me.combo = null
    Maybe that helps...

    Greetz

  4. #4
    Join Date
    Dec 2003
    Location
    Belgium
    Posts
    42

    Re: I want Combo Box to pull up Blank

    Originally posted by Shiloh917
    I have a form on which I have put a Comb-Box with a drop-down field list that either says Yes or No. I have the combo Box set up in my main Table (Emp Data Table) as a combo Box with the dropdown box. On the form I set the control source of the combo Box to feed from that field of the Emp Table. All I want to do is to make it that the box is blank until I actually select the Yes or No answer. How can I do this?


    Thanks!

    Shiloh
    'me.combo = null' sets the combo blank,

    greetz

Posting Permissions

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