I have two tables: "sortcodes" with fields "agentname" and "sortcode"(Unique Id), and "tblitemlist" with fields "itemID"(Unique Id), "itemcode"(Short Description), "description"(Long Description) and "Income/Expense"(Binary). I need a form that will have a drop down to choose the "agentname" from "sortcodes" and display "description", The Word Income or Expense (based on the binary field "income/expense", have a checkbox for whether the item is to be applied or not and a textbox or dropdown to specify a number from 0 to 1 (most entries will be .5 or .75 or 1, this is for a percentage calculation).
"tblitemlist" has 94 entries at the moment and will continue to grow, so I want to have the form display a line item for each record in the table without having to hand code every one on the form.
Once I have this done I will update a third table with a record that contains "sortcode", "ItemID", and "split"(the numeric entry) for every row where the "applied" checkbox is checked.
Can someone point me in the right direction for populating the form without hand coding everything? Should I out the list of items in a subform? I'm sure I can handle the append after the form is filled out, but I'm lost trying figure out how to make it create the subform with the extra controls, Thanks in advance,
Ken
"tblitemlist" has 94 entries at the moment and will continue to grow, so I want to have the form display a line item for each record in the table without having to hand code every one on the form.
Once I have this done I will update a third table with a record that contains "sortcode", "ItemID", and "split"(the numeric entry) for every row where the "applied" checkbox is checked.
Can someone point me in the right direction for populating the form without hand coding everything? Should I out the list of items in a subform? I'm sure I can handle the append after the form is filled out, but I'm lost trying figure out how to make it create the subform with the extra controls, Thanks in advance,
Ken
