G
Guest
Hi,
Let me explain what I'm trying to Do:
I created a table TPerson with 3 elements
IdPerson autonumber primary key
IdType number ( can take the values 1, 2 or 3)
IdPEC number ( the primary key in another table depending on the
IdType value)
Then I created a form with 2 textFields and 3 bound fields to the form's
query.
The 2 fields are ZoneType and ZonePEC. A macro is added for those fields so
that the form is updated whenether the value of the field changes.
The query associated with the form is the following:
select IdPerson, IdType, IdPEC from TPerson
where IdType=[ZoneType] and IdPEC=[ZonePEC]
When I launch the query I get the expected result (let's say) 7 1 3.
But when used in the form, I can't get the bound fields to display 7, 1, and
3 when
I entered 1 in ZoneType and 3 in ZonePEC.
Can someone explain me how to acheive the display of field 7 in a bound field?
Thanks by advance
Let me explain what I'm trying to Do:
I created a table TPerson with 3 elements
IdPerson autonumber primary key
IdType number ( can take the values 1, 2 or 3)
IdPEC number ( the primary key in another table depending on the
IdType value)
Then I created a form with 2 textFields and 3 bound fields to the form's
query.
The 2 fields are ZoneType and ZonePEC. A macro is added for those fields so
that the form is updated whenether the value of the field changes.
The query associated with the form is the following:
select IdPerson, IdType, IdPEC from TPerson
where IdType=[ZoneType] and IdPEC=[ZonePEC]
When I launch the query I get the expected result (let's say) 7 1 3.
But when used in the form, I can't get the bound fields to display 7, 1, and
3 when
I entered 1 in ZoneType and 3 in ZonePEC.
Can someone explain me how to acheive the display of field 7 in a bound field?
Thanks by advance