Forms - multiple record

vince1818

Registered User.
Local time
Yesterday, 16:44
Joined
Apr 8, 2015
Messages
34
how to design a form that can pull multiple invoices data related to the same purchase order number?

any ideas?

Thanks!
 
Sounds like a form/subform situation.
 
Hi Paul,

Thanks for the reply. I tried to use subform but, im not sure how can it pull two data related to the order number. For example, my order number id is 1 and the related invoices are 100 and 200. How can i create a form where i can enter the order id number and it will pull up both invoices data.

Hope to hear back from you or to anyone who can help. Thanks and have a great day!
 
Presuming the order number was also in the invoice table, a form bound to the order table displaying order 1 would display invoices 100 and 200 in the subform (master/child links keep the subform in sync with the main form).
 
Thanks Paul. Yes, the id number is on the order table, where it appears to be duplicated due to related invoice number. I will try to create a subform that will show master/child link. Thanks for your prompt response. Im new to ms access and still learning.
 
No problem, post back if you get stuck. The subform wizard will ask about linking field(s), which should be your order number.
 
Hi Paul,

I was able to create a subform and it worked. I just wanted to check if there's anyway I can make the form view other than DataSheet view. Thanks in advance!
 
I normally use Continuous view for the subform.
 
Hi Paul -

Do you know how to set the form size to 8.5 by 11? So if we need to print the form, it can print to PDF with a letter size format. Any thoughts? Thanks in advance
 
Most of us would recommend creating a report to print or send to PDF. You have a lot more control over the format, etc.
 
I see, can i do a report based from the form I created?
 
Yes, though it may need tweaking. In later versions, highlight the form in the navigation pane, then File/Save Object As
 
I tried to save the object as report but it is not updating. My form contains subform that is continuous view. Its says "the recordset is not updatable". Is better to report based from the table and add a subform?
 
Hi Paul, can i create a subform from a form query? I created a form based on a query. I tried creating a subform but the subform wizard isnt showing up.
 
Hi Paul,

I was able to fix the issue re the printing and the subform is set up. I am on my next step in designing the form and I need your help if you can. I am trying to make the the invoice number and order number barcode font. I am successful in making my order number in a barcode font which is in the main form. However, in the subform, I am unable to make the invoice number as a barcode font, the barcode isnt readable. I am not sure why it is not working in subform. Im using carolina 128 barcode font,

Thanks!
 
Not sure. Is it a size issue (is the subform textbox as big as the main form textbox)? Are the numbers similar?
 
The numbers arent similar. And the size of the textbox are the same. Barcodes are showing up but not readable. And I noticed that same barcode appear as invoice number.
 
Hi Paul,

The barcode fonts are readable if the subform is being executed in a separate form window. But if its in the main form, the subform barcode isnt readable.
Any thoughts? Thanks!
 
Can you post the db here, or a representative sample?
 
hi Paul,

I have attached the sample DB. Let me know if you were able to access it. Really appreciate your help. Thanks!
 

Attachments

Users who are viewing this thread

Back
Top Bottom