Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Dropdown Default

Discussion in 'Information Technology' started by Bill, Jul 28, 2006.

  1. Bill

    Bill
    Expand Collapse
    Guest

    Hey all,

    I'm having a bit of a problem setting a drop down default. I want it to
    default based on the value spit out by a query (it's a min function query so
    there can only be one value). When I set the default value to the line below,
    it just comes up blank. Anyone know how to do this? Can it be done?

    =[Default Value]![Expr1]

    Thanks in advance!
     
  2. Loading...


  3. fredg

    fredg
    Expand Collapse
    Guest

    On Mon, 24 Jul 2006 08:55:03 -0700, Bill wrote:

    > Hey all,
    >
    > I'm having a bit of a problem setting a drop down default. I want it to
    > default based on the value spit out by a query (it's a min function query so
    > there can only be one value). When I set the default value to the line below,
    > it just comes up blank. Anyone know how to do this? Can it be done?
    >
    > =[Default Value]![Expr1]
    >
    > Thanks in advance!


    Doesn't the combo box rowsource have values?
    What if the query value was not in the drop-down list?

    As DefaultValue for the drop-down control, write:

    =DLookUp("[Expr1]","TheQueryName")

    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     

Share This Page