Results 1 to 1 of 1
  1. #1
    Join Date
    Sep 2010
    Posts
    14

    Unanswered: Populate a form with a set of fields from lookup form

    Please Help; need to populate a form with a predecided set of fileds which may be used seperately as well. To be more specific; I have a form (frmTestValues - a continuous form) based on table (tblTestValue) which stores the TestOrderId, Date etc and most important- values of tests , the name of the test is stored in a lookup form and selected (tblTestName.TestName), value is entered against it.
    Now a group of test has to be performed frequently .. like lipid profile which entails selecting TCholesterol, HDLCholesterol and Triglycerides independently each time I have to enter values whenever a lipid profile test is ordered.
    Please suggest a command where I could autopopulate the testValue form with a pre decided set of test names so that I don't have to do a lot of selection again and again. What I would like to do is place a command button on the main form and the after click property should populate the subform (frmTestValues) with TestName ( Stored in a different Table tblTestName- which acts as the lookup table)- but there would be multiple test names not just one!
    a screencap shows the actual table but is name is different in the pic.
    Thanks a lot in advance!!!
    Attached Thumbnails Attached Thumbnails screencap1.gif   Lipids_Examplelbld.gif  
    Last edited by dkc123; 11-26-10 at 02:57.

Posting Permissions

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