database - How to pull up a form based on matching criteria? -

i creating access database data entry. of right now, have welcome screen asks participant number , date evaluation completed. after that, raters taken next form fill out data gathered participant. there way have access pull completed form if participant number , date matches , has been entered? help!

more 1 way accomplish. 1 approach apply filter criteria when opening form. simple example:

if not isnull(dlookup("fieldname", "tablename", "criteria here"))      docmd.openform "form name", , , "criteria here" else      docmd.openform "form name", , , , , acformadd, "new data here" end if 

also, ways pass new data opened form , populate fields of new record. 1 approach use openargs argument of openform (the 'new data here' shown in example). , code behind second form pull values openargs.

if me.newrecord      'code extract data elements openargs , populate fields      'or if opening screen still open,       'just reference controls on form data elements end if 

the real trick figuring out event put code into. keep in mind: 'the more user-friendly, more code'.

when develop code have specific issue with, post analysis.