if anyone can assist me. not a big access programmer, but know basic, as well vb too.
i was wondering, would it be possible to use dlookup function in order to get value from subfrom. i have combo box, and couple subforms. everytime, i change value in combo box, it updates my two subforms. in main form, i have text controls, and i wanted to find out, is anyway, i can use dlookup formula to get values from subfrom based on descriptions.
txtdata1 should get me value (dollar amount) based on condo prices. (please note that condo price description, could be 4th line or 5th, i mean to say it could vary based on combo fild)
texdata2 should get me value (dollar amount) based on projected prices.
would appreciate your help. i mean, i could create a button to run create table query and get value. but if i can can use subform in dlookup formula, that would be awesome.
If IsNull(Text114.Value) Then
Text114.Value = "$0.00"
though, i have one more problem. i have text box, which sums up all the top values from above textboxes. my sumtext box gives me an error saying type mismatch, also it shows value $0.00$0.00 in a filed. would appreciate thoughts on it.