Hi,
Have searched in vain for most of the day for a solution.
I have created a form which includes an unbound textbox which has a dlookup as the control source. This works fine when viewed "stand alone" however when I use it as a subform the DLOOKUP fields return an error.
All of the other data is displayed correctly so I think the master and child fields are linked ok. It may also be pertinent to mention the subform is set up as continuous forms.
I just can't get my head around why it works by itself but not when in the main form.
Any and all pointers will be much appreciated.
Thanks in advance.
BK
Have searched in vain for most of the day for a solution.
I have created a form which includes an unbound textbox which has a dlookup as the control source. This works fine when viewed "stand alone" however when I use it as a subform the DLOOKUP fields return an error.
All of the other data is displayed correctly so I think the master and child fields are linked ok. It may also be pertinent to mention the subform is set up as continuous forms.
I just can't get my head around why it works by itself but not when in the main form.
Any and all pointers will be much appreciated.
Thanks in advance.
BK