Search results

Hey David, I created a query named Data that looks like this QryData Urg_MedicaleDescripID NoAgent Urg_MedicaleDescrip Effectif_tb and my tables are both linked, but I am confused when it come to the form I changed the code to Private Sub Btn_OK_Click() Dim rs As Recordset '...

Yes, but 0;0;1 only shows the NoAgent, but I want the user to see all the data when he clicks on the drop down and when he let's go of the mouse the selection showed only show NoAgent, Also I need to see the dat in the order of... Poste Agent NoAgent

I have a combo box that is bound to an SQL statement.. SELECT Effectif_tb.Poste, Effectif_tb.Agent, Effectif_tb.NoAgent FROM Effectif_tb GROUP BY Effectif_tb.Poste, Effectif_tb.Agent, Effectif_tb.NoAgent; I have it showing 3 fields... but I want it to show only one field... and I don't mean...

Hey David, Thanks for you info, I am trying it right now... Thanks Again

Hey David, I made a few modification, it's kind of hard to explain unless I would e-mail you my db, but let me know if you don't mind. I have changed the table so know it only accept one agentNo but how do I choose 7 agents and save them to that table if I can only see one agent? I am pretty...

I have a form that contains 7 combo box that I can assign to 7 different agents, but when I assign the 2nd agent I would like it to have it's own record in the table, therefore it will increment the AUTONUMBER of my table named Urg_MedicaleDescrip. take all the data but save it on the other...

I was wondering if anyone has ever created an db that is familiar to what I am trying to do. I have form that is unbound, and that has a few combo box, that are alllinked to different table, one of the combox give the choice to add 4 employee names to the form, because there can be up to 4...