Where my problem arises is I need to be able to let the user click a button, enter the desired data into an input box, then update the listbox that contains the data including the new one the user just entered. I originally wanted to update 2 fields in that table by having another inputbox pop up after the 1st was entered. Figured that'd be next to impossible though.
For the life of me I can't figure out how to send the input box data to the listbox via VBA. Can anyone guide me on this please?
This is my query code...
Expand|Select|Wrap|Line Numbers
- INSERT INTO tblIndicator ( [Indicator] )
- SELECT [@Indicator] AS Expr1;