Form in which each field is a default value.

[Abacus1234]

I have a form in which each field is a default value. When I open and close this form I expect it to create a row in the table but it doesn't. Can anyone explain why it does not populate the table. And is there a way to trigger it to populate the table.
Thanks.

[ItsMe]

IIRC, you can use the Default Value property of a bound control to assign a value and doing it this way will create a new record. If it does not, use some code to save the record in the Form's UnloadEvent. If saving, alone, does not do the trick, use VBA to assign a value to one of the fields in the OnCurrent event.

[Micron]

I think you cannot save a record where all the fields only contain default data. At least, in 2007 you cannot - not even in the table itself. You would have to update at least one field, even if it were only by modifying or adding/deleting one character.

[Abacus1234]

Thanks for the responses. I was unable to make headway but eventually found a simpler way of simulating the default record I was trying to create.

I used a macro condition to test if the max id field was equal to the current record I was working on, and if not updated a related record with a "dummy" record (which is what I was trying to do).

If you follow many paths, you may find one that works.