Notes Form

[Haynesey]

Hi, I have designed a call logging database that uses a main form to store details for particular records. Linked to that is a Notes form, where notes can be stored relating to a particular record. This all works fine. What I need to have is some kind of indicator such as a "!" or something on the main form to say if there are notes relating to the record on the notes form.

Is this possible?

Thanks in advance
Lee

 

[Shadez]

Of corse its possible all you have to do is add a TextBox or something to ur main form.

in the control scorce run a query to chk the notes

eg)

iif(nz(dlookup("notes","NoteTable","notetable.callid = " & Callid) ,"") <> "","!","")


this should do the job

ShadeZ

 

[Haynesey]

Thanks. How do I get the query to check if there are records in the note table? Any chance of an example please?

Thanks again
Lee