T
Turin
using WinXP, ACCESS 2003.
on a main form I have two subforms in datasheet view. OCIE_sfrm shows what
is issued to an individual and has four fields, SSN, itemnumr, itemdesc and
qtyissued. STNDISS_sfrm shows all the items available to issue and has two
fields, itemnum, and item desc.
When i doubleclick on an item in STNDISS_sfrm it arbitrarily adds that item
to OCIE_sfrm's underlying table (OCIE) using addnew/update. I want to change
the code so that it checks to see if the item has already been issued. if it
has, then increment the qtyissued field by one. if it hasnt, then add the
item and put a 1 in qtyissued field.
I do not want to search the OCIE table which contains over 100,000 records.
i want to search the OCIE_sfrm which is already filtered.
Do I use the DoCmd.FindRecord? and how do I reference the subforms? please
give examples.
on a main form I have two subforms in datasheet view. OCIE_sfrm shows what
is issued to an individual and has four fields, SSN, itemnumr, itemdesc and
qtyissued. STNDISS_sfrm shows all the items available to issue and has two
fields, itemnum, and item desc.
When i doubleclick on an item in STNDISS_sfrm it arbitrarily adds that item
to OCIE_sfrm's underlying table (OCIE) using addnew/update. I want to change
the code so that it checks to see if the item has already been issued. if it
has, then increment the qtyissued field by one. if it hasnt, then add the
item and put a 1 in qtyissued field.
I do not want to search the OCIE table which contains over 100,000 records.
i want to search the OCIE_sfrm which is already filtered.
Do I use the DoCmd.FindRecord? and how do I reference the subforms? please
give examples.