Getting A Value From A Table Behind the Scene

[jds92257]

Hello,

I’m new to programming in Access and have had some experience with VB. I have a database with two tables (see formats below). On the new entry form I plan to have a ComboBox with a “Find” function. What I’m wondering is once a title is selected, how do I code a query to put the result into [TblName].[TITLE_CODE]?

Thank you,
Joel Stevey

TblName:
LAST
FIRST
TITLE_CODE
ADDRESS
CITY
STATE
ZIP

TblTitles:
TITLE_CODE
TITLE

 

[GingerR]

you dont have to code anything.
i'm assuming the RecordSource of the form is tblName.
you make the Control Source of the combo box be TITLE_CODE and the Bound Column be 1, then the TITLE_CODE will just go into the table.