Access - Problems with a Form

  • Thread starter Thread starter kbronsman
  • Start date Start date
K

kbronsman

Guest
Hello,
I am struggling with a coding problem in Access. I am designing a Purchase Order form for a user to enter in information. I have it so you can pull up the items in the detail section, but it will not pull up the matching description. Also, the form will not subtotal the amount of the line. I tried to write the code to multiply the quantity and the dollar amount to create a subtotal, but no matter what I try, the amount returned is 0. Finally, I created a check box to mark the line item received. But, if you click on any box, it marks all line items received. It will not allow me to receive just one line in at a time.
If you can help me with any of these problems, I would be very appreciative. I have been working on these problems for awhile now and have made no progress.
I tried to upload the dbase, but it says that it is too big. It is compressed and is still 1.9, so if anybody is willing to look at my problems, I can email the dbase. Please let me know what I can do to make it easier for you to help me.
 
I created a check box to mark the line item received. But, if you click on any box, it marks all line items received. It will not allow me to receive just one line in at a time.
You will have to change the "default" view of the main from "Continuous Forms" to "Single Form". Use a subform to display related records from the current record in the main form.
 
Thank you very much. I'll take a look at it and let you know. Thank you again!!!!
 

Users who are viewing this thread

Back
Top Bottom