Hope NOT to get in trouble here

[djclntn]

Guys,

I need some help with a question I may have already asked, but a little differently. In my 'Customers' Form I want to add the field, Saluation which I want to be in a Combo Box Format. I tried 2-different methods: 1) I have the field 'Saluation' in my Cusomers Table & when I tried to implement it into my Customers Form which ever Saluation I choose for one Record copies in all of the other Records. Eg. if in Record-1 I choose "Mr." then "Mr." is in all of my other Records. If in Record-6 I choose/change it to, "Miss" then "Miss" appears inevery other one of my Customers Records. 2) I tried to create my own combo list, buthad similar problems. Any advice would be appreciated!

[Bob Fitz]

Are you viewing your Customer form in Datasheet view?

[djclntn]

<Are you viewing your Customer form in Datasheet view?. Yes

[Bob Fitz]

Have you set the the Control Source property for Combo box?

[djclntn]

I'm sorry in my delayd reply; I had other issues whiith this dbs which needing fixing first.

I just don't understand this Combo List; inthe Customers Table say I have 10-Customers with 'Salutations' of, "Mr." "Mrs" & "Miss". When I go to the Customers Form & try to set up "Salution" as a Combo Box I get a list of all 10-salutation (which I guess is coming from the Customers Table) whereas I just want to see, "Mr." "Mrs" & "Miss" only once in my Combo drop down list -- of course. I don't know what it is I'm doing wrong?

<Have you set the the Control Source property for Combo box?> No, I was unable to do.

[Bob Fitz]

Can you answer a few questions please.

What type of field is "Salutations" in the table?

On your customer form:
What happened when you tried to set the Record Source property of the combo box?
What is the setting of the Row Source property of the combo box?

[djclntn]

"Salutation" is a text field. I have the field size set at 5

The Row Source is, SELECT [Customers].[CustomerID], [Customers].[ctmSalution] FROM [Customers]; & the Row Source Type is set to Table/Query. In return I get a long list of, "Mr." Mrs." & "Miss"

[Bob Fitz]

I know of 2 ways to correct this, I think.

Change the Row Source Property to Mr;Mrs;Miss etc.
Change the Row Source Type Property to Value List
Set the the Control Source property to Salutations
Set the Column Count property to 1
Set the Column Widths property to 1.5cm

The other way to do this involves creating a table to hold the values that are to appear in the list (Mr, Mrs, Miss etc). If you would rather take this route post back.

[djclntn]

Bob,

Let me get back to you sometime tomorrow if I can.

Always, much thanks

[June7]

Don't forget Mz. and could also have Dr., Sen., Rep., Sir, Honorable, Rabbi, Mnsgr, Father, Mother, Fra., Herr, Frau, Snr., Snra., Srta., M., Mdmsl, Mdm., etc.

[djclntn]

Bob,

Your instructions Worked! Hopefully I now have the concept of Combo Boxes & can use this thread/example as a reference.

Thanks!

[djclntn]

Bob,

After I posted another thread on Forms struggling with Combo Boxes I found your thread. Maybe you can take a look if you wouldn't mind.

Thnks

[Bob Fitz]

djclntn

Ok, I'll have a look at that thread.