Results 1 to 4 of 4

Thread: tell me..

  1. #1
    Join Date
    Sep 2002
    Posts
    11

    Question tell me..

    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?

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    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 ?

  3. #3
    Join Date
    Sep 2002
    Posts
    11
    the default value is 0.02

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    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 ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •