Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2002
    Location
    London
    Posts
    73

    Unanswered: Finding a field in VBA

    Hi can anyone please help me.

    What I’m trying to do is on a form there is a check box, if the check box

    ChkGW = -1 then I want a price to appear in a text box txtGWP

    The price is in a table called “PS_tblSettings”, the field name is sName. In the field sname there are lots of records I want to find the record “giftwrapcost” and get the price from the field sValue.

    How would this be written in VBA in MS Access 2000.

    I appreciate your help thankyou

  2. #2
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    I think you can do it with DLOOKUP function.

  3. #3
    Join Date
    Jan 2002
    Location
    London
    Posts
    73
    Just like to say thanks, not sure how i forgot about Dlookup. Thanks once again

Posting Permissions

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