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?
jlevalAsked:
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?
0
 
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?
0
 
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
0
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:
Access-EEQ27831568-AddChildRecor.mdb
0
 
jlevalAuthor Commented:
Exactly what I was looking for, Thank you
0
 
Jeffrey CoachmanMIS LiasonCommented:
Great.

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.

;-)

Jeff
0
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.