Hello,
I have a table called Settings.
The settings table has various fields (such as VAT rate).
The table only contains one row of records.
I want to use this table to set default values of textboxes on various forms throughout my database.
For example if the VAT rate changes I would just change it in the settings table and it would then update in the forms when they are used.
I need to undertand how to set the default value of a textbox to the value in my settings table.
So in this example....
I want to set the default value of the following textbox.
A textbox called txtVATRATE on a form called ORDERS
The value for this would come from a TABLE called Settings and the field in this table called DEFAULT_VAT_RATE
Many thanks Mark
I have a table called Settings.
The settings table has various fields (such as VAT rate).
The table only contains one row of records.
I want to use this table to set default values of textboxes on various forms throughout my database.
For example if the VAT rate changes I would just change it in the settings table and it would then update in the forms when they are used.
I need to undertand how to set the default value of a textbox to the value in my settings table.
So in this example....
I want to set the default value of the following textbox.
A textbox called txtVATRATE on a form called ORDERS
The value for this would come from a TABLE called Settings and the field in this table called DEFAULT_VAT_RATE
Many thanks Mark
