Add A Comments Form to an existing form

I have a form that displays information on certain measurements for tools.

A new feature is being requested-

To add a command button that pops up a Comment form to add comments. The Comment form is associated with a table. On this form, if a note is made on a certain measurement, we want to  have a flag on the form to indicate that that tool number has a note associated with it.

Sounds easy, but we can't add anymore fields to tool measurement form, so no yes /no, field etc.

Is there a way to do  a search that somehow checks to see if a note was made on a particular record like say on an onCurrent event?
Who is Participating?
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
I mean, ...if a Tool had a note,  then would you need a system to reopen the Popup to read the note?

Again, why not put the note on the main form and keep it simple?

I am sure an Expert will come along and help you with this directly, but with what little info you posted on this, I can't really see a need for a separate form.

Going further, ...instead of creating a system to "Check" if as note is added, you could see it right on the form...

Am I misunderstanding something?
Jeffrey CoachmanMIS LiasonCommented:
If this field is on the same table then (AFAICT) a "popup" form is overkill and complicates the system more than it needs to be.

What's the reason why you can't add the notes on the main form itself?
jlevalAuthor Commented:
As I said before, we cant add anymore fields to the table- and I am just doing what my boss tells me. He wants a form that has not just a note, but customers name, date, etc. This is for customer service purposes
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Jeffrey CoachmanMIS LiasonCommented:
<As I said before, we cant add anymore fields to the table>
I apologize, ...I missed that part...

Try this:
jlevalAuthor Commented:
Exactly what I was looking for, Thank you
Jeffrey CoachmanMIS LiasonCommented:

As I thought about this, actually your "separate table" requirement is actually a better design approach.
Now with a separate (child) table/form you can now have "Multiple" notes for each Part.


Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.