ok, i need a way to make an invoice. i have a products table with the number the name and the price of all my products and need to add only the products I want on the report, not all of them but more than 1 ......
ok i have managed to do that by using VB coding to create a mulptiple value parameter query! Now I need to display and the name of the customer buying the products but access does not let me use 2 queries on one report because the tables are not connected it says !!!
Thinking about your original question, it really seem like what you want to do is to have two tables that represent your invoices. One table (InvoiceHeader) that contains one row for each Invoice (each row containing the Id of the Customer to whom you sold products) and a (LineItem) table containing one row for each item you sold on each invoice. The LineItem table would have the InvoiceNumber, the ProductId, the Quantity and the Price and maybe some other stuff.
What it seems like you want to do is to search the LineItem table for the desired products and for each one found, find the CustomerId in the InvoiceHeader table using the InvoiceNumber in the LineItem table. From there, find the CustomerName in the CustomerTable using the CustomerId in the InvoiceHeader table.
Do I understand what you are looking for or am I off track?
If you want to be able to type in this information, you will need to create a form. The form should contain information to orient the person entering the information as well as fields into which the information can be entered. Also, you will need to have a "Submit" and a "Cancel" button.
Put the logic to process the input in the Submit_OnClick() method. If you are using MS Office - Professional Edition, you can generate the this method from the properties window by clicking on the "On Click" event, then click on the "...", then click on "Code Builder", then click "OK".
For Each ctrl As Control In Me.Controls("pnlMainPanel").Controls
If ctrl.GetType Is GetType(System.Windows.Forms.Panel) Then
For Each subCtrl As Control In ctrl.Controls
If subCtrl.GetType Is GetType(System.Windows.Forms.TextBox) Then
If subCtrl.GetType Is ...