John
So, what's to prevent the user from modifying an "old" record AFTER
creating the new one?
If you were so inclined, one approach might be to set the Data Entry
property of the (sub)form to Yes, so that a new record MUST be added (and
no "old" records would be displayed). Then after the new record was
added, you could turn off the Data Entry and see all the current/old
records... with the risk that one could be edited.
If you can provide a bit more description of the business need you are
trying to solve, the newsgroup readers may be able to offer their
experience on alternate approaches.
Good luck!
Regards
Jeff Boyce
Microsoft Office/Access MVP
John said:
Jeff,
Thanks for the reply,
I do want the user to be to scroll backwards to read the previous reviews
but I want to open up on a new
record every time the lookup combobox is changed. Basically just to
prevent
the user editing an old record by mistake.
I know I can set the edit field to NO, but this then gives an additional
problem of the user creating a record and possibly scrolling to read a
previous record and when returning to the current record to complete it,
they cannot as edit is set to NO.
I hope you understand my interpretation of my problem.
Regards
John
Jeff Boyce said:
John
I'm confused.
I thought you wanted the subform to show all applicable records (i.e.,
reviews) for the person selected in the main form. Are you saying you
don't want it to do this, but to open a "new"(empty) record instead?
Regards
Jeff Boyce
Microsoft Office/Access MVP
Hi,
I have a Main Form [frmCandidateDetails] with a subform
[frmsubReviewDetails]
On the mainform is a combobox [cboLookupName] which I select a
candidate and the reviews for this person are shown in the subform.
How do I make the subform goto a new record every time the combobox
name is changed?
Regards
John
