Adding Field Value Rather Than ID Value

[wes9659]

I have created a Button that opens a form that than populates and additional form. However, certain fields that were populated with drop down menu on button form (Title and Church Name) still show the corresponding table ID numbers. I would like to figure out how to have the record shown in opposed to ID value. I have include screen shots. Thank you.

[wes9659]

Attachment 17581Attachment 17582

Cont

[June7]

Options:
1. Include the title and church name as columns in the clergy combobox then the textboxes can reference column index - index begins with 0
=[clergy combobox].[Column](x)

2. include the lookup tables in the form RecordSource