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 ?

the default value is 0.02

Define the label's caption to show .02. If there exists a value in the database for that record then overwrite using rs(fieldnumber) from your query, otherwise it will show .02.

Let me know if this answers your question. Which database are you using ?