Recent content by andymartin3186

Many thanks, this worked brilliantly. The code I used at the end was Dim intPartID As Integer Dim intJobID As Integer intPartID = Me.PartID intJobID = Forms![Job Form]![JobNumber] strsql = "INSERT INTO JobParts (PartID, JobID) Values ( " & intPartID & ", " & intJobID & ")" Debug.Print strsql...

Update - I've done all the work to add the 2nd subform. I just need the code now to put into the button so when I choose a component from the components table it adds its partID as a record to the jobparts table using the current jobID

Hi everyone, I've attached a few screenshots of the existing design, and also the last one which is how I filter to look up my jobs. When I look up my jobs I can type into any one of the top boxes and it filters on this keyword, I can then open the job by clicking the button. I would like to do...

That works as long as you know what you’re searching for which is sometimes difficult as electronic components have part numbers, marking codes, descriptions. Ideally I would like to filter on these multiple fields instead of just a part number combo box then add the desired filtered result to...

Thank you The (link table?) jobparts links job.jobid & parts.partid and also has a qty field. Apologies Im not a programmer Ive built this from scratch over the past 3 months and now it all works Im improving bits The qty used is usually input when adding a part. At present this does nothing...

Hi everyone I currently have a job form, which has a job parts subform which looks up components from a components table. There is currently part number, description, manufacturer, more specifics, supplier price etc and you look up a part to add by the part number which is a combo box. This...

Cheers for that, just knocked one up works a treat 👍

Sounds good. Is the popup a seperate form with critical info?

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.