Create Form to add "Tags"

[GBalcom]

:banghead:

This seems so simple. I'm trying to create a form with two visual "Boxes, and a button in the middle.

The left Box pulls the available "Tags" out of a table, then the user can select what ones apply to this particular record. Choosing the button "Pushes" the selection over to the right visual rectangle. Once I have confirmation that the user indeed wants to add the selected tags (through the save button), I'll add the appropriate records in the junction table through VBA.

What kind of control should the "visual rectangles" be on the form? Should the left be a subform of the continuous variety? If so, how will I know what records the user has selected in VBA?

Thanks for any insight.

I've been away from Access and VBA for too long, and I'm having trouble getting started on this form

 

[plog]

Think you've over-thought and over-engineered this. I would simply have a continous form with one control on it--a drop down. No, VBA, no moving data, no final approval, no manually adding records to a table. Base the subform on your junction table and use it like a regular sub-form.

 

[GBalcom]

OK, I was looking for a Listbox....got it now.

Plog,
I'm interested in your approach. If I understand correctly, I could create a continuous form from my junction table, add it to my main form by linking the ID's, then simply add the tags that make sense right there? Wow, seems easy. I'll try it right now.

 

[plog]

Correct. The real key is going to be making sure the master/child relationship between the main form and subform is set up correctly.

 

[GBalcom]

Much better than what I was hoping for....Thank you Plog!!