C
Charlie
I have created a continuous form based on a query which returns
sample number, date, tonnes, status.
I then have created a text field and placed it in the detail section beside
the other textfields created from the query. I am trying to return in this
new textfield, data which relates to the fields already returned based on the
sample number in the text field already populating on the form.
In the Control source off the new text field I put in the following expression
=[Other Sample Results]![Result]="34.01" And [Other Sample Results]![Sample
Number]=[Sample Number]
when i run the form i get back #name? in that field
It seems to make sense logically to me and it should work but maybe this is
entirely not feasible ! can someone show me a better method.
I am doing it this way because if i use a join query to get this additional
information, the query become not updatable, and i need to be able to update
details.
thanks
sample number, date, tonnes, status.
I then have created a text field and placed it in the detail section beside
the other textfields created from the query. I am trying to return in this
new textfield, data which relates to the fields already returned based on the
sample number in the text field already populating on the form.
In the Control source off the new text field I put in the following expression
=[Other Sample Results]![Result]="34.01" And [Other Sample Results]![Sample
Number]=[Sample Number]
when i run the form i get back #name? in that field
It seems to make sense logically to me and it should work but maybe this is
entirely not feasible ! can someone show me a better method.
I am doing it this way because if i use a join query to get this additional
information, the query become not updatable, and i need to be able to update
details.
thanks