>Eric,
>I tested the code and I was able to bind the fields to the Textboxes.
>The problem with the code is that it does not allow me to navigate through the records. So I guess I will need to set the CursorType property of the RecordSet??.
You need to add controls to move!!! Add 2 command buttons to your form. One will do a recMyRecordSet.MoveNext and the other recMyRecordSet.MovePrevious. You will have to validate yourself errors at BOF and EOF.
>(How do you the change to white the background of the screen when displaying code?)
Tools->Options->Editor Format->Background
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com