R
Razor
Hi,
I have a form in which each record is a different product.
Within each product are six textboxes for six different
regions.
I need to popup a combo box that will accept a value from
the user when a user enters one of the region textboxes.
The combo box should offer a picklist of date values
in "yymm" format with a default value of the previous
month (e.g. today it should offer up "0401" since the
current month is "0402")
After the user enters the value in the combo box and the
value in original textbox and exits the textbox OR the
record, the code should then write out the following 5
values to corresponding fields of a separate "tblHistory"
table:
productID,
regionID,
popup combobox date value and
textbox $ value
today's date
Could someone show me the code to do this? I'll need to
graph the values per region per product using the records
in the "tblHistory" table.
Thanks,
Razor
I have a form in which each record is a different product.
Within each product are six textboxes for six different
regions.
I need to popup a combo box that will accept a value from
the user when a user enters one of the region textboxes.
The combo box should offer a picklist of date values
in "yymm" format with a default value of the previous
month (e.g. today it should offer up "0401" since the
current month is "0402")
After the user enters the value in the combo box and the
value in original textbox and exits the textbox OR the
record, the code should then write out the following 5
values to corresponding fields of a separate "tblHistory"
table:
productID,
regionID,
popup combobox date value and
textbox $ value
today's date
Could someone show me the code to do this? I'll need to
graph the values per region per product using the records
in the "tblHistory" table.
Thanks,
Razor