Results 1 to 3 of 3
  1. #1
    alex_raju is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jun 2011
    Posts
    56

    Question copy from popup form to main form

    i have a access main form named "salesinvoice" with this data field "invoiceno","barcode", "description","qty","price".
    when i enter barcode no on "barcode' field other all details will appear automatically, now if i cannot find barcode on product (physically) of course i want search in search form by description,price or model.
    to search when cursor on "barcode" field if i press f12 key search form will open, till this everything ok.

    now my doubts is ..


    if i search by description in search form sometime i can find more then one record , i want select proper barcode from search form rows by arrow key and if i enter from that cursor selected field barcode no should paste on "salesinvoice" form "barcode" field
    how i can do this ?

    please


    alex

  2. #2
    alex_raju is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jun 2011
    Posts
    56

    Talking solved

    actually i received perfect answer from mr.pillai (accessforums.net)

    Private Sub srchBarcode_DblClick()
    dim BC as string
    BC = me![srchBarcode]
    Forms![Invoice]![barcode] = BC
    end Sub

    thank you very much..

  3. #3
    vbbbmom is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Posts
    1
    Quote Originally Posted by alex_raju View Post
    actually i received perfect answer from mr.pillai (accessforums.net)

    Private Sub srchBarcode_DblClick()
    dim BC as string
    BC = me![srchBarcode]
    Forms![Invoice]![barcode] = BC
    end Sub

    thank you very much..
    This helped me today! Thank you!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. copy data from a subform to the main form
    By declanfogarty in forum Programming
    Replies: 1
    Last Post: 06-23-2011, 05:31 AM
  2. Updating Main form from a popup form
    By wdrspens in forum Forms
    Replies: 21
    Last Post: 06-13-2011, 01:34 AM
  3. Popup Form
    By NISMOJim in forum Forms
    Replies: 1
    Last Post: 10-23-2010, 09:16 AM
  4. Replies: 10
    Last Post: 09-27-2010, 08:06 PM
  5. copy info in subform as well as main form
    By Coolpapabell in forum Forms
    Replies: 0
    Last Post: 09-30-2009, 10:02 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums