If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can't save record
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 |
Thread Tools | |
Display Modes | |
|
|