E
Elisa
Hello everybody,
I am using microsoft access 2002. I have a problems with a form.the
form opens a query whose fields are:
A
B
C
D
where all the fields are text but D, which is a yes/not field and of
all the records have A="X".
I would like that in the form, for only one of the records, I could
set D=Yes (as if I had a query for the fields A and D for which A=X
and the count of D=YES was 1).
had I tried to set D=YES for one record (where in the query there is
another record that have D=YES) I would like to have a error message
back.
can anyone help me? I hope I have made myself clear, as I am not very
good in english!
thanks a lot
ELisa
I am using microsoft access 2002. I have a problems with a form.the
form opens a query whose fields are:
A
B
C
D
where all the fields are text but D, which is a yes/not field and of
all the records have A="X".
I would like that in the form, for only one of the records, I could
set D=Yes (as if I had a query for the fields A and D for which A=X
and the count of D=YES was 1).
had I tried to set D=YES for one record (where in the query there is
another record that have D=YES) I would like to have a error message
back.
can anyone help me? I hope I have made myself clear, as I am not very
good in english!
thanks a lot
ELisa