Drop Down Lookup List box (Newbie - Sortof)

A

atlpeekr

I have a form I created that populates a tabel in an access database. There
is a List Box I want the user to lookup the name of a client from another
table that will populate the "ClientID" in the primary table. My tables
appear as follows:

SMR
- SMRID
- ClientID

Clients
- ClientID
- ClientName

When I configure the Drop Down (Bind to the ClientID in the primary table
and Lookup Data from Clients Table as secondary DS), the form "Changes" the
value to the data type it's bound to. How can I maintain the Text
appearance on the form?
 

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

Similar Threads

Drop Down Lookup - Please Help!! 0
Drop down list control value in vba 2
Drop down lists in seperate columns 5
Link a text box based on drop down box with four options MS Word 365 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
list or combo box 0
Creating a Search using a combo box and then creating a report. 4
drop down list 1

Top