Ap******@gmail.com wrote:
How do I use a combo-box to do a lookup on my name table
“T-NAME”, and then place the values found in the lookup table (ie
LNAME, FNAME, MI) into to a row in my existing continuous forms table
"T-SICK" ?
I will have the combo-box lookup available in each row of my
continuous form bound to "T-SICK" to make this happen.
Thanks
Let's say you have a table called TSick with the field TName. This
field links to Tname in NamesTable.
What I'd do is add your table NamesTable to the form's recordsource.
Click the ... on the forms recordsource from the property sheet under
DataTab. Add the table NamesTable. Make sure there's a link line
between the Tnames in both TSick and NamesTable. If not, drag Tname in
Tsick to Tname in Namestable.
Now dbl-click on the line. Change it from #1 (both equal) to #2 (or 3)
where All in Tsick and Matching in NamesTable.
Now drag you first, last, mi fields to the recordsource query. Close
the query for the recordsource.
Now add First, Last, MI to your form from the field list. If you
already have them, verify the ControlSource for each field (under
DataTab) is correctly bound to the fields you added in the recordsource
query.
Now when you make a selection from the combo box Tname, the name fields
will fill in.
Out Of Space
http://www.youtube.com/watch?v=u7edztkuz5o