Recent content by kernowboy

I'm trying to populate a field in my form from a query. Can someone please give me some help. I've been trying to figure it out from the web but can't get it sorted. I've got a combo box that selects a member of staff from a table, and then a query runs which takes the value from that combo...

Hi Kev, Thanks for your fast reply, however, I've literally just managed to solve both of these problems with one action. The sub-form I had in the customers table was locked so this was causing the filter error message and the blank form problem. Many thanks

Hi Kev, Thanks for your reply, here's a copy of the database attached, I'm using Access 2010. Also, another problem I have is when starting to enter data into the frmcustomer, I get the message up "Access cannot apply the filter because all of the records are locked", I have looked in the form...

Hi, Could someone help please. I have a form frmcustomer, that has a subform in it tbljob subform, that is view only. I have added a button to "create new job" which closes the frmcustomer and opens frmjob, so that I can add a new job to that customers list. However when I click the button...

Thanks guys for all your help, I've totally re-structured the database now on your recommendations, now also added sub forms after reading info on this site, and now also got the cascading combo working using queries. Great site, I'm enjoying creating my database and finding this site an...

Hi, Thanks for your reply. I have taken that advice on board and started creating my forms (only rough layouts at present). I have tried sorting out the combo boxes using one of the methods I found on this forum but I can't seem to get it to work. Have attached my latest file. Can anyone...

Hi, I wondered if someone might be able to help me please. I'm trying to create a database for my construction firm. This is the general structure of it:- I have the following tables set up:- tbljob with the fields:- JobID (primary key) Job Name Job Address Client Name Client Address Client...