Pop-up form for selection of options

[danikuper]

OK Access Gurus, this I think is a tough one.

I would like my users to click on a button in my form. This will pop-up another form with some choices they can make through check-boxes. When they have finished selecting their choices and click on OK, a text box in the main form will show their selections and a table will be updated with the value of this text box.

What's the best way of accomplishing that?

I know how to create the button and the pop-up form however the part of getting their selection to the text box and updating the table is driving me crazy.



Let me know if additional details are needed.... THANKS!!!

 

[WayneRyan]

danikuper,

The popup form contains only checkboxes.

What would you expect to see in your textbox?

YYNYNNNY or
TTFTFFFT or
-1-10-1-1-10

Or a list of all fields checked?
FieldA, FieldB, ...

Need more info ...

Wayne

 

[danikuper]

Wayne,

Thanks for the interest.

The pop-up form will have names of people, like:

John
Mary
Robert
Grace

Next to each name, a checkbox that the user will check if he wants to add one or more names to the record.

Back to the previous form, I'd like to see in the text box those names that were checked. So if John and Mary were selected, I'd like to be able to get to the text box something like:

John / Mary

If Joh, Robert and Grace were selected the result would be: John / Mary / Grace.

Is this possible?

thanks again

 

[danikuper]

Yes, Pat. I understand that. In fact, I do have my tables set up that way:

Table: Order
Fields: OrderID (key), OrderDate, Customer, TotalAmount, Product, ShipDate

Table: Rep
Fields: RepID (key), RepName, RepTitle, RepRegion

Table: Rep-Order
Fields: OrderID (key) , RepID (key)

One order may have one or more reps associated with it. One rep may be in one or more orders. So I have setup the tables above to represent the many-to-many relationship.

I wanted to give my users an easy way of entering orders and establishing the rep-order relationship. So I thought that would be nice if for assigning reps to orders they could just use a list and checkboxes. While the text box in the main form would show multiple names (e.g. John / Mary / Grace), in the background Access would be entering the following information into the Rep-Order table:

OrderID RepID
001 ABC
001 DEF
001 GHI


If you think there's a better way of handling this situation, please let me know.

Thanks for the input, I really appreciate your help.

 

[neileg]

Sounds like a Multi Select List box may be a better bet?

 

[danikuper]

Humm... yes, this could work.

I think I can manage creating a multi-select list box based on my Rep table (I've seen this somewhere) but how can I get the values selected from the multi-select list box back to my rep-order table?

 

[danikuper]

OK, I'll try that too.

I'll post my results.

thanks!

 

[hangglide]

I have a better solution. Make a subform that looks like a multi-select list box and save yourself a lot of coding.

I am interested in making a sub-form that looks like a multi-select list box maybe even with check boxes (so it looks like the "Categories" selection in Microsoft Outlook). I have my many-to-many tables set up correctly. Currently my subform just looks like a table with a combo box for each new record. It is not very user friendly. Do you have any suggestions?