Search results

Got it, I was using Job ID to link instead of Serial, changed the master and child and it works! Thanks

If I run the subform with the job form open it also displays data, its just not displaying data in the subform in the main form. All the record sources are correct

Still empty, where do I put the code to requery the subform? on the main form load? Is strange how I run the query with the form open and it displays the data, its just not showing in the subform

Update - if I run the query with the job form open the query runs fine and displays the previous job, just the subform isn't working correctly for some reason?

I managed to get the subform in fine and set it up as continuous forms It displayed the current job so I added the following criteria into the query under JobID column <>[Forms]![Job Form]![JobID] I created a test job with a matching serial number to an older job but it displays nothing now...

Hi Everyone I have a job system which the main table stores information about a current job, in this it stores the serial number of that job item The main form shows all the data about the current job including the customer and contact. I would like it to have an area where it displays any...

Hello Many thanks for the welcome. I last did access in 2002 at college so slowly picking it up. I will check this out, appreciated.

Hi Ive created a database which is a job system I have a customer table and each customer can have many contacts which are stored in a separate table. The customer form has a subform and this works showing all associated contacts The issue I have is when it comes to creating a job. The job table...