onclick event to create message to user

[MaryMoseley]

I use a database which uses form to give us a list of contracts. The list has a link which will pull up the research on that contract. It is impossible to remember which contracts you have "researched" for closing. I need anyone who double clicks a contract link to be "asked" to enter a date in a Research_Date field. The date wouldn’t be required, since they could be doing contract inquiry versus update. I know nothing about coding VBA or macros.

 

[Ranman256]

when they click a research item, can you open a form with a list box of all possible dates. (removing the hit/miss of guessing a date)
Then they dbl-click the date in list, to open a detail form.

 if txtBox = "Research" then
    docmd.openform "frmPickDate",,,"[recID]=" & txtID
 else
 ...
 endif

'then when dbl-click date:

 sub lstDAtes_doubleClick()
    docmd.openform "frmResearch",,,"[Date]=#" & lstDates & "#
 end sub

but if you want to enter a date
put it in the query criteria... [enter date]

 

[MaryMoseley]

That makes sense. I will give it a try. Thanks for the input!