Can anyone please help me with the following problem?
I wish to set the default value of a Combo Box on a form, whose source is a table. An example is "Order Status Code", that can have the values Outstanding; In Progress; Completed etc. On a new order I wish the Order Status to default to “Outstanding”
Whilst I realise this can be achieved by setting the default value to the record key of the table that holds the values, doing it this way means that to change the default value, a user of the application would need to have the opportunity of amending the table properties, which I do not wish to allow. I would prefer that the user have the option to determine the default Order Status by the use of a flag or parameter held on the appropriate record by use of a table maintenance form. i.e. set a flag to a value of ”D” to the appropriate record.
I wish to set the default value of a Combo Box on a form, whose source is a table. An example is "Order Status Code", that can have the values Outstanding; In Progress; Completed etc. On a new order I wish the Order Status to default to “Outstanding”
Whilst I realise this can be achieved by setting the default value to the record key of the table that holds the values, doing it this way means that to change the default value, a user of the application would need to have the opportunity of amending the table properties, which I do not wish to allow. I would prefer that the user have the option to determine the default Order Status by the use of a flag or parameter held on the appropriate record by use of a table maintenance form. i.e. set a flag to a value of ”D” to the appropriate record.