I'm trying to work through Drew Jensen's tutorial employee database and
I've run into a ditch with subforms, in particular the "EmployeeNotes"
subform, which has a single textbox control for the note text. The notes
are kept in a separate table, linked to the main table through the
EmployeeID.
I have this working, as far as I can tell, but some aspects of the
function of this text field are "less than ideal":
1) I set the "Navigation Bar" property to "Parent Form", but if I make
an entry in the subform, then click "Next Record", the entry is lost. I
have to specifically click the "Save Record" button to update the data
store. For fields in the main form, editing then moving off the record
is sufficient to save the changes.
2) Sometimes, after I type some text in the Notes text box, I have to
move the mouse around or click in a different field before the Save
Record button activates for the subform.
Is this expected behavior?
What I'm really looking for is that the subform should behave completely
as if it was another field in the main table.
For the bigger picture, is there any way to implement a form where you
make your changes on a temporary copy of a record, then press an
"Update" button to commit the changes? The default field-by-field
editing is very awkward. I mean, I'm sure it *can* be done; is there any
newbie-friendly checkbox or menu where I can switch it on?
Thanks for your time!
<Joe
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
