Display more 1 recordset on subform

Please assist,

User will make a request(s) to add/change/delete orderset(s).
When administrator received requests, s/he will send user the existing
orderset date with blank fields to make suggested changes to existing
orderset.

Main form has user contact info ,request # and combo lookup.
When orderset in combo is selected, it populates subform.

Problem: Need to populate more than 1 orderset on subform

Below are my tables:
table: Order Request
OrderRequestid
userid
date
ordertype
requesttype

table: Order Request Detail
orderrequestid
orderid
chemid
chemchg
formchg
unitchg

table: Order Set
ordersetid
chemid
chem
form
unit

There will be many chemicals in 1 orderset.

Thanks,

Can you give us some examples of what you want to do? I'm not understanding
your description of the task that you want to accomplish.

--

Ken Snell
MS ACCESS MVP

"Gwen" wrote in message
...
Please assist,

User will make a request(s) to add/change/delete orderset(s).
When administrator received requests, s/he will send user the existing
orderset date with blank fields to make suggested changes to existing
orderset.

Main form has user contact info ,request # and combo lookup.
When orderset in combo is selected, it populates subform.

Problem: Need to populate more than 1 orderset on subform

Below are my tables:
table: Order Request
OrderRequestid
userid
date
ordertype
requesttype

table: Order Request Detail
orderrequestid
orderid
chemid
chemchg
formchg
unitchg

table: Order Set
ordersetid
chemid
chem
form
unit

There will be many chemicals in 1 orderset.

Thanks,

Thanks for asking. Hopefully, this will make sense.
I want the selection(s) from the combo box to display in the subform.
When the admin gets a request to change an orderset(s), the admin will look
up what's currently in the system and send the records via Excel to the user.

admin wants to select orderset1 and orderset2
desired display on subform:
orderset1 chem1 liquid ea
orderset1 chem2 gas lb
orderset2 chem1 liquid gal
orderset2 chem2 gal ea

The user will send back the same records but with recommended changes in
separate fields.
orderset1 chem1 liquid ea recommendedChem recommendedForm recommendedUnit

It has been suggested that I use a listbox instead of a combo box for
multiselection.
However, there are about 200 look up rows.

"Ken Snell (MVP)" wrote:

Can you give us some examples of what you want to do? I'm not understanding
your description of the task that you want to accomplish.

--

Ken Snell
MS ACCESS MVP

"Gwen" wrote in message
...
Please assist,

User will make a request(s) to add/change/delete orderset(s).
When administrator received requests, s/he will send user the existing
orderset date with blank fields to make suggested changes to existing
orderset.

Main form has user contact info ,request # and combo lookup.
When orderset in combo is selected, it populates subform.

Problem: Need to populate more than 1 orderset on subform

Below are my tables:
table: Order Request
OrderRequestid
userid
date
ordertype
requesttype

table: Order Request Detail
orderrequestid
orderid
chemid
chemchg
formchg
unitchg

table: Order Set
ordersetid
chemid
chem
form
unit

There will be many chemicals in 1 orderset.

Thanks,

I'm not fully understanding what you want to do, but the way one combines
data from two seperate data sets is via a union query. You'd write a query
that gets the data for your orderset1, and a query for data from orderset2,
then you'd use a union query to combine the two data sets -- this union
query would add calculated fields to allow the desired sorting and to
identify the orderset from which the record came (you'll need this last
information in order to edit the data with the updates from the users).

Using a union query, you then can show the combined data on one subform.

Alternatively, you could use side-by-side subforms (two subforms) to show
each orderset independently.

You can use TransferSpreadsheet to export the data to an EXCEL file.
However, because you cannot control what the user does with the EXCEL file
in terms of data deletion, resorting, moving columns, etc., reimporting the
data automatically may be tricky or not possible.

I'd need to see some examples of real data in order to make suggestions for
the union query's composition, as I don't see an obvious way to sort on a
"chem1" and a "chem2" identity (I assume that those are just generic
identies that you're using for the purpose of this post).

--

Ken Snell
MS ACCESS MVP


"Gwen" wrote in message
...
Thanks for asking. Hopefully, this will make sense.
I want the selection(s) from the combo box to display in the subform.
When the admin gets a request to change an orderset(s), the admin will
look
up what's currently in the system and send the records via Excel to the
user.

admin wants to select orderset1 and orderset2
desired display on subform:
orderset1 chem1 liquid ea
orderset1 chem2 gas lb
orderset2 chem1 liquid gal
orderset2 chem2 gal ea

The user will send back the same records but with recommended changes in
separate fields.
orderset1 chem1 liquid ea recommendedChem recommendedForm
recommendedUnit

It has been suggested that I use a listbox instead of a combo box for
multiselection.
However, there are about 200 look up rows.

"Ken Snell (MVP)" wrote:

Can you give us some examples of what you want to do? I'm not
understanding
your description of the task that you want to accomplish.

--

Ken Snell
MS ACCESS MVP

"Gwen" wrote in message
...
Please assist,

User will make a request(s) to add/change/delete orderset(s).
When administrator received requests, s/he will send user the existing
orderset date with blank fields to make suggested changes to existing
orderset.

Main form has user contact info ,request # and combo lookup.
When orderset in combo is selected, it populates subform.

Problem: Need to populate more than 1 orderset on subform

Below are my tables:
table: Order Request
OrderRequestid
userid
date
ordertype
requesttype

table: Order Request Detail
orderrequestid
orderid
chemid
chemchg
formchg
unitchg

table: Order Set
ordersetid
chemid
chem
form
unit

There will be many chemicals in 1 orderset.

Thanks,