G
Guest
Hi all,
I'm trying to control a form's text boxes (whether they are enabled or not)
based on the value of a field in a subform.
I have it designed so you can have many records in the main form which
relate to one record in the subform.
I have tried using SQL in the main form (SELECT CEP FROM tb_Frame_Download)
to no avail - I keep getting '#NAME?'
I am absolutely tearing my hair out over this, could anyone please help?!!
Many Thanks,
Phil
PS -
Also as for redesigning the schema, I'm afraid there simply isn't a way
round it - I have to have this many to one relationship.
And it is essential I grey out these boxes or else it will comprise data
quality in that only certain combinations of values are allowed.
I'm trying to control a form's text boxes (whether they are enabled or not)
based on the value of a field in a subform.
I have it designed so you can have many records in the main form which
relate to one record in the subform.
I have tried using SQL in the main form (SELECT CEP FROM tb_Frame_Download)
to no avail - I keep getting '#NAME?'
I am absolutely tearing my hair out over this, could anyone please help?!!
Many Thanks,
Phil
PS -
Also as for redesigning the schema, I'm afraid there simply isn't a way
round it - I have to have this many to one relationship.
And it is essential I grey out these boxes or else it will comprise data
quality in that only certain combinations of values are allowed.