How to get value of two combobox(s) into textbox in datasheet subform.
Posted on 2004-08-31
Hi Every one,
I have datasheet subform, which have 4 fields.
For some reasons I have to store a CONumber which is actuall the combination of customerid and orderid. let see
CustomerId = 100
OrderId = 5001
so CONumber = 1005001
how should I get CONumber in datasheet subform at save time?
I Set the control source property of Textbox to CONumber Field, and update it with afterupdate event of Product (combobox) but then Value won't store in field. If I try to do it before update event There is a error because of both combobox(s) are empty at that point.
so whats the best way to get the way... of both after its been update but not yet store in the underlying table.
Thanking you in advance....