Is it possible to save a record that has no user-input values, but only
Default Values?
Based on the information you supplied I say no unless you are using an
autonumber for primary key.

--
Build a little, test a little.


"BruceM via AccessMonster.com" wrote:

I asked a question yesterday in the Forms Programming group, but have not
received a reply, so I am trying again with less detail and a different
subject line.

Is it possible to save a record that has no user-input values, but only
Default Values? The record in question is in the top level table. At first
it contains only a date. Later, when the subform records are processed,
there will be more data. However, as it stands subform records are orphans
because Access does not recognize a main form record, and therefore there are
no values in the linking field.

I could solve the problem by making the user input the date, or using a
command button to add the date, or some such, but since the date is almost
always today's date I would rather automate its entry.

I could use If Me.NewRecord to add the date, but if the user navigates to
another record without adding subform records there will still be a parent
record. I would probably have to run a Delete query of some sort to get rid
of the childless parent record.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201002/1

.