i hav a difficulty which in my form ,there is a label name discount(lblDiscount).it can only b view by the staff, and the staff are unable to change the detail. it means that, discount is control by my database. the thing is, the lblDiscount shows nothing when i run my form.it's blank. but when i save my form, the discount field in the database is updated with the default value i set. how can i make lblDiscount to show it's value based on database?
Are you populating other database information on the same form as the discount ? If so, then just put that field in your query and lblDiscount = rs(x). How are you displaying the value for the lblDiscount now ? What is default value ?