I found this code for the AfterUpdate field on a report so that I can pull up the record relating to the Primary Key that was entered.
Here is the link:
http://access.mvps.org/access/forms/frm0005.htm
here is the code:
'****** Code Start *********
'Move to the record selected in the control
Me.RecordsetClone.Findfirst "[ID] = " & Me![ComboOrListboxName]
Me.Bookmark = Me.RecordSetClone.Bookmark
'******* Code End *********
Unfortunately I'm still such a beginner when it comes to code, I don't know how to translate this to my database.
So, the report is based on the table Participants. The primary key field is AppID. AppID is a Combo box.
I want to enter in the AppID and if it matches a record, pull up that record. If it doesn't match, allow a new record to be created.