-- snip --

>I may do that, but I'll have to decide on a maximum number of required fields (probably 6 to 10) and add that many parameters. Is there a way to select the object which has a specific tab order (which may not be 1) without checking the taborder property of every object on the form? I may be able to get around this, but it would be nice to have a way. Thanks for the suggestions.

Bret: I pass a parameter for the Unique (Primary) ID, which is used in the INSERT statement to add the new record. This is part of my
CmdAdd::Click() method and is read from the ID file which holds the unique ID values for each table. Then any further defaults, such as a foreign key or default date are added with a replace statement in the PostAdd() method.

Barbara