Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004
    Posts
    36

    Unanswered: Opening a form based on individual record

    All my records are displayed on a form. Upon clicking on their respective 'View' button, I would like to open that particular record. How can I do that? I have attached a screenshot for better clarity. Thanks in advance for the help!

    Regards,
    Swee
    Attached Thumbnails Attached Thumbnails view.jpg  
    Last edited by machix; 10-06-04 at 03:57.

  2. #2
    Join Date
    Apr 2003
    Posts
    59
    You can use visual basic. If the record is selected, as shown in your screen shot, then you should be able to pick up the PO Number. You can then use this in a WHERE string when opening another form (I assume when you say you want to see the record that it is another form?). This is also assuming that your PO Numbers are unique.

    If this is not clear then please ask again - I never know how much detail to go into on the first reply!

  3. #3
    Join Date
    Aug 2004
    Posts
    36
    You got your assumption right. Thanks dude. Got it working now.

Posting Permissions

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