By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,028 Members | 1,315 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,028 IT Pros & Developers. It's quick & easy.

ComboBox lookup

P: n/a
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
Jun 27 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Jun 27 '08 #2

P: n/a
Thanks Salad that worked well !

Greg
Jun 27 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.