Use default value and linked fields to create a new record?

[CarlyS]

I have a form used for data entry with several subforms which store data for specific times of day. The date is entered on the mainform and stored in each "TimeOfDay" subform. This setup allows for data to be analyzed by day or by a specific time of day. I have default values for data in the "TimeOfDay" subforms. I would like to be able to save default values as if they were entered data so that there is no unnecessary data entry.

I understand that Access does not recognize the default values as new data, even if the Master/Child links update the date field of the subforms. Is it possible to create an extra field and automatically enter data into that field so the rest of the default data will be stored as a new record for that date and time of day?

I have tried using a macro to set a value, but if I do this before or after update or insert, it never creates the new record. If I do this on unload, it says I cannot set the value for that control.

Is there any way around this?

Carly

 

[quest4]

In my dbases, if I hit enter, while focus is on the txtbox, the default becomes the data in the table, unless it is an unbound txtbox. The only other thing I need to do at this point is save. Hope I was clear enough for you. hth.

 

[CarlyS]

I tried that... still, no data saved. Is there something special about the textbox you are hitting enter on?