Ok, I have my Form all set up and working how i want it to, for the most part. I have a table called tblJobs, and that is where the ListBox (lbDisplay) on my Form gets the information from. So my ListBox is displaying four fields from tblJobs: JobID, CustomerID, InvoiceID, and [Piece Done]. But, I found that I need to add a few Fields from another table in my DB. Can I just modify the Row Source code to add the new fields I need? Or would I need to make a Querie, combine the Tables, and make a new Form? I've FINALLY gotten the Form to look and operate how I want it, and would be kind of annoyed that I have to make a whole new Form based on a Querie. So if anyone can help, I would appreciate it immensely.
*Edit*
Oh yea, the code I have currently for my ListBox's Row Source is :
SELECT tblJobs.JobID, tblJobs.CustomerID, tblJobs.InvoiceID, tblJobs.[Piece Done], * FROM tblJobs WHERE (((tbljobs.JobID) Like "*" & Forms!frmNow!tbSearch2 & "*")) Or (((tblJobs.CustomerID) Like "*" & Forms!frmNow!tbSearch2 & "*")) Or (((tblJobs.InvoiceID) Like "*" & Forms!frmNow!tbSearch2 & "*")) Or (((tblJobs.[Piece Done]) Like "*" & Forms!frmNow!tbSearch2 & "*")) ORDER BY tblJobs.JobID;
I have it like that because the ListBox is linked to a TextBox so that when you start to type a JobID or CustomerID or anything like that, it will display all the occurences of that string. If anyone wants me to upload the DB as i have it now, just say so and I'll try and get that up. Thanks in advance
*Edit*
Oh yea, the code I have currently for my ListBox's Row Source is :
SELECT tblJobs.JobID, tblJobs.CustomerID, tblJobs.InvoiceID, tblJobs.[Piece Done], * FROM tblJobs WHERE (((tbljobs.JobID) Like "*" & Forms!frmNow!tbSearch2 & "*")) Or (((tblJobs.CustomerID) Like "*" & Forms!frmNow!tbSearch2 & "*")) Or (((tblJobs.InvoiceID) Like "*" & Forms!frmNow!tbSearch2 & "*")) Or (((tblJobs.[Piece Done]) Like "*" & Forms!frmNow!tbSearch2 & "*")) ORDER BY tblJobs.JobID;
I have it like that because the ListBox is linked to a TextBox so that when you start to type a JobID or CustomerID or anything like that, it will display all the occurences of that string. If anyone wants me to upload the DB as i have it now, just say so and I'll try and get that up. Thanks in advance