And I just pray someone here actually knows it.
Ok, I've got a project called prjTodsTyres. I've got a frmMain which then leads to frmJobs. This can be seen in This Picture. From here you can view Tod's many tyre jobs. This part works. So next you click on Create Invoice, which opens frmInvoice.
Now, this is where it gets crappy. I've included all of the frmInvoice code at the bottom of the page so anyone with experience might go through it and point my errors out, much appreciated.
When frmInvoice loads, it gathers the incorrect information. As you'll see in that picture I linked to, i've picked to make an invoice for Blue Fox, yet Ritual's details come up. This is the code I used to theoretically produce Blue Fox details:
datInv.RecordSource = "SELECT FROM Customers WHERE CompanyName = frmJobs.txtCustomer "
I've double-triple-quadruple-checked those names. datInv points to the correct database, and does indeed select data from Customers>CompanyName. Only problem is it always picks the first file's data, Ritual. This happens for every customer.
I also have a problem with the discount code, but i'll ask about that after I get help fixing this problem.
P.S. Haste is appreciated, since the deadline is today. Thanks so much for any consideration you put towards this.
Ok, I've got a project called prjTodsTyres. I've got a frmMain which then leads to frmJobs. This can be seen in This Picture. From here you can view Tod's many tyre jobs. This part works. So next you click on Create Invoice, which opens frmInvoice.
Now, this is where it gets crappy. I've included all of the frmInvoice code at the bottom of the page so anyone with experience might go through it and point my errors out, much appreciated.
When frmInvoice loads, it gathers the incorrect information. As you'll see in that picture I linked to, i've picked to make an invoice for Blue Fox, yet Ritual's details come up. This is the code I used to theoretically produce Blue Fox details:
datInv.RecordSource = "SELECT FROM Customers WHERE CompanyName = frmJobs.txtCustomer "
I've double-triple-quadruple-checked those names. datInv points to the correct database, and does indeed select data from Customers>CompanyName. Only problem is it always picks the first file's data, Ritual. This happens for every customer.
I also have a problem with the discount code, but i'll ask about that after I get help fixing this problem.
P.S. Haste is appreciated, since the deadline is today. Thanks so much for any consideration you put towards this.
Originally posted by My Code
Comment