Problem linking textbox to a query

[danbli]

Hello!

I have some problem with an old accessdb that needs some fix up.

I have form with many fields in it(which I didn't create).

I have one textfield that has the recordsource "PNC" and I'm gonna put
another textfield that shows the modelnumber for this PNC(partnumber).

I have linked a table that has both the PNC and the modelnumber in it and i
have tried to make a question that get's the modelnumber with the criteria
Forms![nov_form1]![PNC] where nov_form1 is the name of the form. The textbox
that gonna show the modelnumer has this recordsource
=[PNCMODEL]![C2MODL]

The sql for the question is
SELECT EUPMA_EUPPFC2.C2PNUM, EUPMA_EUPPFC2.C2MODL
FROM EUPMA_EUPPFC2
WHERE (((EUPMA_EUPPFC2.C2PNUM)=[Forms]![nov_form1]![PNC]));

If I run the question in querydesigner and I put in a valid PNC in the box
that comes up I will get the right PNC and modelnumber from the linked table,
It is only in the form I cant see the modelnumber.

I really need some help with this...!

With best regards
Daniel Blixt
Sweden

System Developer
Electrolux IT
Mariestad Plant

 

[Jeanette Cunningham]

Daniel,
Instead of using criteria in the query, create a new query that joins both
tables and inculde the fields for PNC and the modelnumber in the query.
Use this query as the record source for the form.


Jeanette Cunningham -- Melbourne Victoria Australia