Is it possible to build a form from another form

[lisedum]

I am building an parts inventory system in Access and have trouble working on
the structure.

They have a Material Requisition which is numerical and sequential.

They then take the Material Requisition with all the info except the number
and generate a P.O. which is also sequential.

Then the person handling the P.O. takes the P.O. and adds a suffix (three
letters) which is the vendor's abbreviation. Sometimes there is more than
one Purchase Order with the same number but different vendor abbreviations
for the same purchase order since there are different parts from different
vendors on the same material requisition.

They would like all this to be linked but I think they are dreaming.

I know Access quite well and am learning Visual Basic as I go along but I
have no idea how to structure this mess.

 

[Duane Hookom]

Is there supposed to be a question in there some place?

 

[lisedum]

Sorry, a little frustrated at the time, but I did solve one problem.

I now have a form that has two subforms built in. One for a requisition
with requistiion details subform that belongs to a parts table, and another
subform that only adds a purchase order number which is an autonumber along
with two other fields that represent location and method of transport. This
part works well.

Now I need to create another form from this form for another person that
needs to break down the purchase order by vendor. He would be using the same
purchase order number, and affix a three letter ID for the vendor. Sometimes
there is only one vendor, but at times there are three or four different
vendors.

I don't know if this is possible, but would appreciate any assistance if
this is possible.

Thank you.

 

[Duane Hookom]

Could you please reference data tables with names and fields and data types
and sample records and desired results?

 

[debra turner]

yes you can copy the form and rename it. of course you will have to make
sure the form is pointing to the correct Query. Also some of the fields in
the other query might be different and want apply to the newly copied field.
it will have to be modified to fit your needs. It is all pulling from the
same table?

Table-input
Query-Output
Form-Input
Report-Output
How easy is that to remember!