Stuck with combo boxes for ever !!! :(

[Evgeny]

I have been suffering with combo boxes for a week now... and no results. I am new to access, i am picking up concepts fairly quick, but combo boxes got me completely stuck. I have attached my database, please edit rowsource and VbA for Contact and Contact Email, so Contact Email auto populates (And lets me choose any Contact for a new record rather, then displaying the same one in every record).
I have tried everything, but seems like i am not experienced enough to get it going

[Datagopherdan]

I didn't open your database but from the sounds of it, you don't have your combo box attached to a control source. For example, lets say that the record source for your form is tblNotes, which tracks all correspondences you've have with each client. You would want a field in there for the Client, we'll call it ClientID. You would then set a relationship with that field with your table that has all your client information, e.g. Name, E-Mail etc. You would set that relationship on the unique identifier in tblClients, which should be something like an Auto-Number, which we'll call ID

Now, in your combo box on the form, set the control source to "ClientID" and you create a query that would pull from your table with all the client information. You would want the ID, Contact Name, and E-Mail. Now, set your number of columns property to 3 and set the column widths to 0,1,1. Now your combobox will be connected to that field and display the client name and email for each record.

Dan
Access Development

I have been suffering with combo boxes for a week now... and no results. I am new to access, i am picking up concepts fairly quick, but combo boxes got me completely stuck. I have attached my database, please edit rowsource and VbA for Contact and Contact Email, so Contact Email auto populates (And lets me choose any Contact for a new record rather, then displaying the same one in every record).
I have tried everything, but seems like i am not experienced enough to get it going

[sesproul]

Which Form are you talking about?

[Datagopherdan]

The form that you have your combo box on.

Dan
Access Development

Which Form are you talking about?

[Evgeny]

Datagopherdan thank you, the best simplest and best explanation i have had so far. Worked out just fine . Solved.

[Datagopherdan]

YW. Glad you got it worked out.

Dan
Access Development

Datagopherdan thank you, the best simplest and best explanation i have had so far. Worked out just fine . Solved.

[Evgeny]

Decided to add ContactID to my table for relationship purposes.

[Evgeny]

Datagopherdan could you please look at my data-source please, it started messing around with me. kind regards, really urgent work thing

[Evgeny]

attached DB

[Evgeny]

Solved. I created combo box with record source of Name, Email. Column Count 2 (1;0). Then text box with control source = [ComboBoxName] !! Thank you for your help mate