I am using VB 2010 for a menu and code & MS Access 2007 for tables. I am using data binding to lock a text box to an Access table. I want to input text into the text box and press the TAB key or the ENTER key to go to the next text box. At the same time I want the text in the first text box to be transfered and appended to the Access 2007 table. Thank you for any thoughts you can share on this.

Normally when you use data binding the control is bound to some object that has a notion of the current record. You need to figure out which record that is and make it move to a new record. That should update the value in the current record to whatever is in the TextBox.

If you want to create a new record, you need to call that object's AddNew method (or whatever method it provides for creating a new record). You then need to call it's Update method when you're done to accept the new record.

Overall I think data binding might be a little confusing for this. I would probably just use a SQL INSERT statement (or some other direct database method) instead of data binding to add the record when focus moves to the next field.

__________________
Rod

Rod Stephens, Microsoft MVP

Essential Algorithms: A Practical Approach to Computer Algorithms

(Please post reviews at Amazon or wherever you shop!)