Question Subform Help Required

wendy mcintyre

New member
Local time
Today, 16:57
Joined
Jul 21, 2009
Messages
2
Hi .. I’m using a Microsoft standard database template called “Order Management Database”. I have tried to adapt this to suit my needs but I need to change the sub form “Order Details Subform” to display all products rather than just selecting one at a time, then up-date the other tables after I enter the quantity. Is anyone familiar with this template and know if this is possible? I am not a programmer just a basic access user .. although I have used bits and pieces of easy code here and there.

Thank you
 
Welcome to AWF!

It should be possible to do what you ask.

I will assume you want the order to list only items with a quantity <> 0.

I would like to suggest a different approach that will keep you from having to add a delete lots of records. I would use a Pop=up form that list all the items with a place for quantity. When the user clicks a "submit" button, run an append query to add all the records with a quantity to the order. This way the order will only have records with a quantity.

This wil allow you to not have to change the order for except for adding a command button for selecting items which opens the pop-up form that I described.
 
Dear HiTechCoach,

I will give this a go today. Thank you so much for your help.

Wendy
 

Users who are viewing this thread

Back
Top Bottom