Access 2000.
I am attempting to make a sub-form with 2 list boxes.The sub for is going into a employee info database. One list box contains data(list1 will contain all department names) from a table, One list is empty(list2 will contain the departments that are selected from list 1). I have set up a cmd button to add a user selected entry from list 1 into the empty list two (the info from list two will populate a many to many table).
I have started copying the code from a database that has this same setup.
I am receiving the following error:
“COMPILE ERROR—–SYNTAX ERROR”
The code that is causing the error is as follows:
“& “Where (((consumerprogram_tbl.Consumerid) = & str(currentconsumerid) & “)) ”
& “ORDER BY prim_prog_tbl.programid;”
Are there any obvious errors? Is there an easier way to do this?
Any help is appreciated