Recent content by forceflow

Aceman-- That worked perfectly. You just saved me a ton of time! forceflow

Getting a compile error for db as DAO.database "User defined type not defined" Ideas? forceflow

Did it. Thanks Aceman

Aceman---- tblJobFiles Check box qty: 23 Starting Position in table: 8 (counting "0" as 1) forceflow

Roger that Aceman. Leave data type as "YES/NO" for now?

When you say respective entry do you mean for example to change the name of the table fields to ListA0, ListA1, ListA2, etc? forceflow

Exactly! Other 20 fields can be deleted after data is merged over to mmoProducts so the data can then be displayed in the frmJobFiles!lstProducts instead of using 20 check boxes on the form. forceflow

Excellent Code Aceman! Not one hang-up or glitch! A couple other things now that I have all that working: What about a method to completely clear the frmJobFile!lstProducts field? How can I convert existing table fields that are not null into the mmoProducts field? I originally used check...

Aceman---- I had planned on entering each of the values for each popup list box in my preferred order of display. I hope that frmJobFiles!lstAllProductsSelected can display like this: First or "top" row(s)of "lstAllProductsSelected" would be the selected data from lstA on popup (of course in...

Aceman: Would rather have lstA B C order than alphabetical forceflow

Will not exceed 2048. Thanks forceflow

Aceman--- Hate to complicate things but what if I wanted to have three separate list boxes on the popup form, then combine the items chosen in each of the three to display in one list box on the main form? Possible? or ugly. Example: On Popup form: lstA = Item1 and Item4 selected lstB =...

Aceman..... You rock! Perfect code. works great. I have wanted to find a way to do this for the last year, looked on Tek-Tips from time to time and finally asked. Big thanks!!! [thumbsup2] forceflow

Oops--Sorry about that on the columns. Single column is all that is needed. I will have probably 5 to 10 rows in the column. Popup form name "popSelectProducts"

Aceman---- Memo type field on main to be called "mmoProducts" Popup list columns: 5 (six product names) I will actually be having three separate list boxes where I need to do this procedure but for learning purposes, one will work great. Main: frmJobFiles!lstProducts Sub...