i creating database contains product information (tblproductinfo), list of test methods (tbltests), , results product gets (tblresults).
i'm adding forms user can enter results of previous or new product. information added once testing product done. so, able show list of tests tbltests, , have user enter results in text box of sort displayed directly next tests. can't figure out way so, save results user entered.
i have created form subform, subform shows 2 columns (tests , results) , when change allow dataentry, gets rid of test names. need keep test names displayed, allow entry in results column.
any ideas? below screenshot of example of like, although need results column empty.
create continuous subform tblresults recordsource, , header or each field of results use related test label how it. set allow additions yes, allow edits no allow deletions no.
Comments
Post a Comment