• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 399
  • Last Modified:

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?
0
jleval
Asked:
jleval
  • 4
  • 2
1 Solution
 
Jeffrey CoachmanCommented:
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
 
Jeffrey CoachmanCommented:
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
 
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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
Jeffrey CoachmanCommented:
<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 CoachmanCommented:
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now