Displaying Record with autonumbered primary key in a form

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
I found a option that make the 7 display.
Set the "Data Entry" to No in the "Data" tab of the Form properties.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top