I've created a form in Access-2007.
The form is not bound to any tables or queries. It is for data entry and programatic purposes only.
The goal of the form is to provide a workspace where a user can enter some data, then press a button to display one of several analyses.
Since the raw data will be coming through an ODBC link, I saw no point in binding the form to a table.
1) My basic problem is that the form is not accepting user input. Buttons work, I can use VBA to set control values and manipulate the dummy chart I'm displaying. I do notice that there is still a status bar shown on the bottom of the form, though. Do any of you have a clue why my text and combo-box controls aren't accepting information?
2) Am I even using the appropriate tool? Would Excel (with VBA) be a better choice?
Thanks