>-- 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
Sorry I didn't reply sooner. I thought for a while about your answer. My cmdadd uses an APPEND rather than an INSERT, because that's how the wizard did it. I seem to remember that there was a thread explaining why INSERT is better, but I can't remember what its reason was. My required fields have no default values, so I don't want to save a record with the wrong values filled in. The table that I was given has no primary key. I am getting them to add stuff so that unique keys can be generated, but for the moment it has to work without them. Are you saying you copy your primary key values to another table?