Hi!
I cannot find a solution to my problem:
I have a continuous subform named "Sub1". This subform is a result of a query. There are two main values in query "function" and "sumofquantity".
I have created another form with this subform. A also have few textboxes "text1", "text2", "text3". I need to make Dlookup function:
Subform:
function sumofquantity
"cutting" 100
"preparing" 200
"packing" 50
Form:
permanent textboxes:
"cutting"
"preparing"
"packing"
blank texboxes: (dlookup quantity from subform)
"text1"
"text2"
"text3"
I need to dlookup values from subform to each blank texboxes in form. I will set this function to OnLoad event of the form.
Many thanks for help!