Replies

Another issue I seem to be having is with my code stopping on Me.cboCompanyRep.RowSource = “SELECT Company Rep FROM” & _
” tblContact WHERE Company = ” & _
Me.cboCompany & _ < error grabing the value from the combobox
saying Compile error:
Method or data member not found

Thank you for the link.
I added the SELECT [tblContact].ID, [tblContact].Company FROM tblContact ORDER BY [Company]; statment to combo box cboCompany and when the form is ran it shows the primary key values. is there a way to offset one more column?

What I am exactly after is setting the row source to a table, called customer and I query all in the field called Company. The next combo box is where I am having trouble. I would like to query only Company Reps names from Customer table where the company name is = to the company selected in the first combo box.

Hopefully this makes sense.

Thanks Ahead

ok thanks I will try this

Thank you, I will try this. How do I set a reference to excel though?

no for some reason when I goto the directory the file type in unreconized, when I goto Properties the name has “savename”

well thank you Hans

Run-time error ‘1004’
Application-defined or object-defined error

Sheets(vOfficeSheets).Visible = True is highlighted yellow

Thank you hans

the list would be a string varible hard coded within the sub routine

thanks Hans

Hi Hans,

If I am reading this right you can embed a word document in an excel spread sheet?

how do I do this?

Thanks

Thank you

My apologies, I am looking for the unique values and not the duplicates. I changed my original post but you are very quick and thank you for that

I have a problem with a list that is 1 col by 6000 rows
the problem is there is unique values (30 to be exact) in the list and I want to find them
Any one know a way to do this