Recent content by tim bailey

Jal, Thankyou that worked a treat. You are a lifesaver tim

Jal, Sorry for the confusion. Your dlookup worked fine but was only returning one result. I may of misunderstood your solution and if so let me apologise. I require the result as you said to populate a combo box but with multiple values. So I had a play and using the VBA help managed to...

Thanks for that Unfortunately some of my customers have several sites as such i need to be able to list them hence the recordset approach. However it has helped my way of thinking. If you have any more ideas they will be appreciatted. I have been working on this for three days solid now with...

Ok, I am making some headway at last and then wham another brick wall. Please help!! I have created a form that takes its values from a standard sql select statement in VBA. That works. I then created a second combo box that in turn uses another sql statement from an on click event...

Thanks for this, however I am struggling to understand your method. I have since created a single unbound form on this form i have 2 combo boxes. the first populates using a query Private Sub Form_Load() Dim id As String Dim cname As String Cbocname = "select [company name] as cname...

Hi, Sorry to bother you guys with such a newbie question but I have a problem where i need to use a query in VBA to derive some values for use in another query. What I am trying to do is this: I want to open a form that checks the values of the user input (company name)against the...