Continuous form Combo box control

[dinsey90]

Hi,

Overview: Trying to create an access database that will allow us to invoice for jobs within the company. We can have 100s of jobs running at the one time ranging from huge to one item. I have 3 tables; tblJobs; tblItems; tblsInvoices. I have created a form that allows the user to create a job and it adds to tblJobs. tblItems will hold every item that is involved within that job. I need a form that we can use to add these items in under the specific job number. I would then need a form that allows me to select the items for the job add in all the items that are being invoiced for on that particular day (this needs to update to show the told left to be invoiced) and then let me generate a report/invoice from that to send to the customer. When it is paid i can then go in and mark it as paid or if it is disputed then i can mark it as disputed or part paid and the totals will reflect that. ApologisesInvoicing Database.zip if i have not explained it very well. Any help you can offer would be brilliant.

I've inserted a zipped version of the very bare template i have at the minute

Tables & Fields
tblJobs
Job_Number - primary key
Client_Name
Job_Name
Start_Date

tblItems
Type
TP_Number - lookup from tblJobs
Item_Number - primary key
Total_ex_GST

tblInvoices
TP_Number
Invoice_Number - primary key
Invoice_Date
Amount_Invoiced
Amount_Approved
Amount_Rejected
Retention
Payment_Made
Previously_Claimed_Dollar
Previously_Claimed_Percentage


Payment_Assessment_Dollar
Payment_Assessment_Percentage
This_Claim_Dollar
This_Claim_Percentage
Outstanding_to_be_Invoiced

I have a continuous form that i need to display all the items for a specific job. (Sub Contractor)
We have a lot of different jobs running at once so I wanted to use a Combo box in the header of the form that will control the continuous form and only show the items that are related to what is in the combo box. I also need a button that will let me add another line to the form so that more line items can be added to that job number?

I was going to try and use the set filter after update of the combo box but I dont know if that would work correctly. I'm also not sure what code to put behind the button for adding a new line?

Any help would be greatly appreciated.

[ranman256]

you have a frmJobsList, continuous form with all jobs.
a Detail button in the header to open the selected job and see the details, (single record form)
docmd.openform "frmJobDetail",,,"[Job_Number]=" & me.txtID

the detail form will have a subform to show ALL items, owned by this job#.
you can add items here,
or
make an Add record form,
combo box to pick the job
text box to add the item
and any other info,
click the add button to run an append query that reads from the form and adds to the table.

[dinsey90]

Thanks,

I've create the 2 forms frmJobsList and frmJobDetail. When i put the code behind the details button though it comes up with an error saying me.txtID not recognised.
Also how can i create a subform that will show all the items owned by the job#?
Cheers

[ranman256]

I used txtID , you must use the name of the text box you use for the key.

the subform CAN be a form, but it can also just be the table or query.
table.tMytable
or
query.qsMyQuery

make sure you LINK MASTER and LINK CHILD fields on the key.

[dinsey90]

Thanks but when i put in the Me.TP_Number the name of my field, when i click the details button it asks for the parameter value to be inputted before it will open the form?

Cheer for the help sorry if i'm not picking up all your advising fairly new to this