Hello there everybody. This is my first post to P2P so please forgive me if my formatting is not what is commonly used around here.

I have been tasked at work to make quite a simple sheet however i have come to a bump in the road, I have a query with a lot of data on so to refine this i have made a few select forms allowing key points to be seen without as many eye straining cells.

On the first form " TimeSheet_Table_1_Query_Form_Front " Please let me know if that name is to long :)!, I show some job information IE Job name, Job description, Job number.

There are two in particular interest to us.

Jobnumber(Text80) and partnumber(Text82) I can rename these also if needed.

I will be adding a search box on the header to filter this in those two parts, probably a text box to type in the job number and a drop down to find the part number.

What i would like however is a button, that dependant on what is displayed in Text80 and Text82, to open up a second form "Timesheet_Table_1_Query_Form_AddData" where the job number and part number automatically filter to what was on the previous form. So our staff can just add the new data that is required and close it again.

I hope this makes sense i struggle to explain things on my mind to people so please let me know if something needs explaining differently.

Kind regards

FloppyPoppy

EDIT : Sorry i missed this off, on the second sheet that we would like to pop up when the button is pressed, there are two boxes that contain the same job/part number info. Job number (Jobnumber1) Part number : (Partnumber1). If they can match up here when pressing the button through VBA that would be a very good leap for the project.