access quiry

[ruudvdmeer]

A simple question maybe:

I have a simple table with two columns; an PERSON_ID and a NAME.
In a second big table I have also an entry of PERSON_ID

Now I want to make a form for the second table with a field NAME. I know how to write text to a form-field (using Visual Basic), but how do I get the NAME from the simple table?

 

[TonyJollans]

Hi Ruud,

Base your Form on a Query which links the two Tables (instead of just on the one Table) - use the Query Builder and you shouldn't find it too difficult. Do post back if you can't manage it or have specific questions about it.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[