How to get the data from a query into a form

[ManuelLavesa]

Hello all, my problem is as follows. I have a PurchaseOrder table and a PurchaseOrderDetails table. I made a form to enter the purchase orders. and works correctly. I also have a query that finds the products that need to be ordered from an specific supplier. What I would like to accomplish is to get the result from the query and enter it into the form so that the data gets written into the respective tables, and the Purchase order is generated automatically. Is this possible? and if so, how is it done. Thank you for your help

[orange]

Can you how us a screen capture (jpg) of your relationships window?
To get data into your tables, you use bound Forms--that is use Forms that are bound to your Tables.

[ManuelLavesa]

Thank you for your reply. I already made a bound form, and I can enter data manually, the data is written into the tables perfectly. The problem is that I would like to get the data from the query result into the bound form and I don't know how to accomplish it.

[orange]

Tell us about the query --more details and example would help.

And the relationship jpg?

[ddoumani]

Orange; I have the same question posted in another thread/area and it probably should have been in this subforum. Short is that I want to put a specific data label, which I can get in a query, in a form as an identifier. Sounds like the same solution for the OP and myself would be applicable. Any ideas if you reference this post I made with a bit more details?

https://www.accessforums.net/showthr...941#post317941

[orange]

ddoumani,

I do not understand your requirement enough to offer more advice.
I did respond to your other post --seeking more info.

In order to offer a focused response, readers have to understand your situation. Some may guess, and guess correctly with little or no info. I don't think guessing is a good strategy. In my view, if a poster can not describe the "problem/opportunity" sufficiently well so that a reader can understand the context and the main requirements, then the poster probably does not fully understand the issue or has not analyzed the situation in detail.

Good luck wth your project.

[ManuelLavesa]

I am sorry it took me a while to return to programing. The query is a select query that finds which products need to be ordered for a specific supplier. It also calculates the quantity needed to order. But once the query runs is not updatable. So when I make a form based on this query I can not change the values of the fields. So ideally what I want is to make an updatable query... Or maybe if I describe what I need there might be another way. What I need is :
1) findout which products for a specific supplier are needed to reorder
2) Generate a Purchase order for all the products in an editable form.
3) edit the quantities and products as needed and print the purchase order.
What do I do currently.
I have the query that gives me what I need to order thus solving 1)
I have a form bound to the Order detail table and I enter the information from the query manually so that it is editable. Then I generate a report and print the PO
So my dream is to make this data entry automatic and editable just in case I want to change the products or quantities ordered is there a way to accomplish this? Thank you for your help and time