John,

If you want the user to add a new record, you should add the new record before the user starts editing so that the table is not at EOF. If you're trying to do something other than add a record you may want to change the control source of the text box so that it isn't a field in your table.

>I have a form with 5 related tables. Several of them are simple lookup tables and are not used in every master record. When I bring up a record for edit and a text box control source table is at eof() becuase there was never an entry made I cannot enter that text box. I assume it is becase the table is at eof(). How can I have the user get into that text box and enter data. I am using Optimistic Table Buffering.