Please help!! Access queries and forms

[inneed]

Please help!!

I am creating a program that will allow the user to select a sale and pull up only those product items associated to that sale in the details. Any help would be appreciated. Then with in the details section the user will/should be able to enter in the Quantity needed to order. Any suggestions on how to do this. My tblSale does provide the data needed so how do I get the data to go to the form?

I am new to this forum so if I have not asked properly I apologise now.

The Database is attached. Form Orders is the form that I am using to accomplish my task. The getproducts4Sale Query is the information needed.

 

[sha7jpm]

some help maybe...

off the top of my head it can be done like this... (bearing in mind this is my understanding of your question and it may be more complex than this...)

also, there are many people way more advanced at this than me so if I have advised you badly then apols in advance!!

1. create a form based on a query based on your tbl.

2. create a dropdowm box (combobox) populated with your sales

3. place a subform (based on a query with the fields you require) onto your form which is linked to your main form (this is the master child id link eg id number is in both forms and that is the link, one is the master (main form) and one is the child (subform)

4. then you should be in the situation where you click on a sale in the combobox which updates the subreport to show the details, then you can input the data you want..

You need to search this site for key words such as sub form and combobox and you should be able to knock something up...

if you require further refinement in your selecting of a sale eg select by area and then select by sale then you can do this with a cascading combobox but that is another step on..

hope this helps a bit...

John.

 

[inneed]

Thank you

Thank you John. I will give this a try I did try this rought to some degree but got frustrated and back away from it so I go at it again. Thank you.

Teri