From Newsgroup: comp.databases.ms-access
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.21b-Linux NewsLink 1.2