Continued Help With Combo Box

[wes9659]

Hi Thank you for all your help I still am not following as to where you want me to put the
=[clergy combobox].[Column](x). I striped the project down and attached it Clergy zip 2. I entered some bogus data. I tried originally in stops where I thought it went either got no data in place or still only the corresponding field ID’s. I am assuming it is something easy I am missing which is usually the case. I would greatly appreciate if someone could look and see what is wrong fix it and repost. I usually have great success than dissecting it out at that point with explanation. Thanks everyone once again for all your help. I am so loving Access and what it can do.

[June7]

The ClergyName field in Primary_Data_Table is TEXT type and must be NUMBER type (long integer) because the PK field in tblClergy is an autoNUMBER. Related PK and FK fields must be same type - in this case NUMBER not TEXT.

You need to fix this for all tables where autoNUMBER PK is saved as FK.

Name parts really should be in separate fields: LastName, FirstName.

You have alias field names set in table (Caption property) - advise not to do that. Example: ClergyName field in tblClergy has caption First Name.


Form with issue is PersonalizedChoices?

In ClergyTitle textbox ControlSource:
=[ClergyName].[Column](2)

In ChurchName textbox ControlSource:
=[ClergyName].[Column](3)

etc.

[wes9659]

I have tried what you said and still I am unable to make it work I still get the numbers in fields rather than corresponding text from the fields. I set fields to number long integers in the primary_data_table I even tried setting fields in Clergy Table to number long integers. I strip relationships reapplied them. I know there has to be a way to do this. The concept is basically I want to click on create Clergy Button located on PersonalizedChoices Form Add information from the pop up form and have it repopulate on my personalized form after double click on Name field located on personalizedchoices Form. I hope someone can help. I am a novice and frustrated ugh!! Thanks everyone for you indulgence and patience with me. I have also uploaded striped form again here. I am sure it is quick fix just missing it!!!

[June7]

The latest posted db does not implement the changes I suggested in post 2.