1. Forum
  2. USENET
  3. comp.databases.ms-sqlserv

  • default value on combo box

    From Remigio@linoreale@gmail.com to comp.databases.ms-access on Tue Sep 22 04:40:58 2020
    From Newsgroup: comp.databases.ms-sqlserv

    Hi to you all,
    I want to assign a default value on a combobox in a form using one of the fields of the query that feeds the form.
    I tried to put in "default value" on combo box several combinations but they don't work:

    id_ausilio_lancette
    [q_maschera].id_ausilio_lancette
    [q_maschera]!id_ausilio_lancette
    =[id_ausilio_lancette]
    =[q_maschera]!id_ausilio_lancette

    How can I referr to a query field as default value?
    Other solutions?
    Thanks and regards
    --
    Remigio
    --- Synchronet 3.21d-Linux NewsLink 1.2
  • From Mike P@mikewpayne@tiscali.co.uk to comp.databases.ms-access on Wed Sep 23 02:05:05 2020
    From Newsgroup: comp.databases.ms-sqlserv

    On Tuesday, September 22, 2020 at 12:41:03 PM UTC+1, Remigio wrote:
    Hi to you all,
    I want to assign a default value on a combobox in a form using one of the fields of the query that feeds the form.
    I tried to put in "default value" on combo box several combinations but they don't work:

    id_ausilio_lancette
    [q_maschera].id_ausilio_lancette
    [q_maschera]!id_ausilio_lancette
    =[id_ausilio_lancette]
    =[q_maschera]!id_ausilio_lancette

    How can I referr to a query field as default value?
    Other solutions?
    Thanks and regards

    --
    Remigio
    Hi Remigio,

    How would you select the record in the query that feeds the form, to provide the field [id_ausilio_lancette] that will be the default for the combobox?
    Bear in mind that a default value appears when the form shows a "New (blank) record" at which point there is no source record for the form; id_ausilio_lancette will be null.
    What is the Row Source for the combobox?
    You could set the value of the combobox after a record has been created in the form.

    Mike P.
    23/9/20
    --- Synchronet 3.21d-Linux NewsLink 1.2