Quote:
Originally Posted by r_shawn
Does anyone know how to get an unbound control to automatically update the db once someone enters info into different forms.
For example, I am building a db for a scheduling system for a career services center. I had to create a lot of forms from scratch, but I have all the fields in tables that relate to these forms, but they were just not bound to these fields when I created the forms.
Is this a problem or will I still be able to update the db with unbound controls? Can this be done with code, and if so how and what?
Thanks so much, Robin
|
You can bind the forms to the tables after the fact and then assign the unbound fields in the form to the fields of the table. If you are entering data in one form whose fields are in more than one table you can create a query of all the tables (if three or more tables, the form's RecordsetType property hasto be set to Dynaset (Inconsistent Updates)) associated with a particular form and then bind that query to the table and assign the fields as above.
If this doesn't meet your needs, let me know.