Search results

Hi Cbrighton

Hi I have attached a copy of the DB, I would appreciate any pointers.... I am using the formquote form. When I enter data into client details that is not in the list it asks me if I want to enter a new client and I reply Yes and this takes me through to the clinet form. Add the new client...

Hi Good idea, Ive attached the DB again Many thanks

Hi Not sure if the attachemnt will work as all tables are linked into an MySql database, we are just using access for front end use.... However I have them linked because 1 client can have many sites.... So if in Combo 1 I select Leeds Site in combo 2 I would selct Bradfor Site or Wakefiled...

Hi Linq Please exucse me but I ma not so hot on coding.... I ahve changed my code as I think you suggested but I still get the Vis Bacis Endbug message and the line Combo44.Requery is highlighted in yellow. My full code below..... Any other ideas or if I misuderstood please put me right...

Hi I have a very simple two tables and I have searched for a simple example for this on the web but no luck so far, so i hope someone can help. I have two tables tableClient and tablesite. These are linked by key fields client.clientid and clientsite.clientsiteid On a quote entry form I...

Hi Sorry that is not quite what I am after and seemsmore complex than my code below (sorry not to up on programming). I have tried to add in the rerquery command but I get a debug error and it does not like the combo44.requery. Any ideas... and thanks Private Sub...

Hi I have a combo box which holds client information. When I type ina word notinlist it prompts me to say it is not in the list (as per code below).. When i go to add the new client and then go back to the quote screen the new customer is not displayed. If I close the quote form completely...