view only the new record

[Guest]

Hi,

To enter a new meeting and related information on an established client, I
have a client form linked with a meeting subform by clientID in a 1: many
relationship. The meeting subform is set data entry yes, allow edits yes,
allow additions yes. On the data entry form one combo box determines the
record source for another using a "me.recalc" command after update. Once this
happens, the record is saved and the prior meeting records for this client
become available. By scrolling the mouse wheel for example, the user can view
and alter the data inputed for prior meetings with this client. This leads to
confusion and mistakes. I want the user to only be able to view and add
content to this latest record. If I set "allow edits" to no, the screen
freezes after the recalc event and does not allow further data entry. This
seems like it should be such an easy set up. What am I doing wrong? thanks.

 

[Guest]

I would think you could use the DMAX function on the newly created MeetingID
(I'm assuming the child table has an id generated with the AutoNumber data
type.

Then you could use that MeetingID in the Queried Row Source for the form, in
other words, only that one record would show.