G
Guest
I have a table, tblMediaTypes, with three fields, strMediaType, curPrice, and
lngCount. There are four records…CD, DVD, Hub Printable CD, and Mini CD. I
want to create a form where I can choose the record(s) I want and have a
blank field where I can enter a number that will get added to the number
stored in the lngCount field for that particular record. I don’t need to
keep the number I entered in the blank field because the next time I open the
form I will want to enter a new number that will again get added to the
number stored in the lngCount field for a particular record.
Example: record CD has a lngCount of 500. I enter 400 into the blank field
so the new lngCount for CD is 900. The next time I open the form record CD
starts with 900. Thanks in advance for all of the help.
lngCount. There are four records…CD, DVD, Hub Printable CD, and Mini CD. I
want to create a form where I can choose the record(s) I want and have a
blank field where I can enter a number that will get added to the number
stored in the lngCount field for that particular record. I don’t need to
keep the number I entered in the blank field because the next time I open the
form I will want to enter a new number that will again get added to the
number stored in the lngCount field for a particular record.
Example: record CD has a lngCount of 500. I enter 400 into the blank field
so the new lngCount for CD is 900. The next time I open the form record CD
starts with 900. Thanks in advance for all of the help.