Hi, all.
I used below after_update code to dlookup particular data on my parent form. It did what i want.
Me!Material = DLookup("imdsc1", "tbl_itemmaster", "IMLitm = forms![frm_itemRequestDetail]![ILcode]")
Eg, i choose dept code and it auto show dept name in my unbound field on the parent form.
But when i came into subform (datasheet view) i applied above function into a dropdown field. It did lookup the field but it failed somehow
Eg,
subform
ColA..ColB...ColC
1... .... B......Boy
2........A......Boy
3........C......Boy
4........D......BOy
When i choose B from the dropdown box, it change the colC to Boy and does not remain the others.
Note : ColC is unbound field
Hope u could help...
Thank you very much
I used below after_update code to dlookup particular data on my parent form. It did what i want.
Me!Material = DLookup("imdsc1", "tbl_itemmaster", "IMLitm = forms![frm_itemRequestDetail]![ILcode]")
Eg, i choose dept code and it auto show dept name in my unbound field on the parent form.
But when i came into subform (datasheet view) i applied above function into a dropdown field. It did lookup the field but it failed somehow
Eg,
subform
ColA..ColB...ColC
1... .... B......Boy
2........A......Boy
3........C......Boy
4........D......BOy
When i choose B from the dropdown box, it change the colC to Boy and does not remain the others.
Note : ColC is unbound field
Hope u could help...
Thank you very much