Add A Comments Form to an existing form

Posted on 2012-08-16
Last Modified: 2012-08-16
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?
Question by:jleval
    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    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?
    LVL 74

    Accepted Solution

    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?

    Author Comment

    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
    LVL 74

    Expert Comment

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

    Try this:

    Author Closing Comment

    Exactly what I was looking for, Thank you
    LVL 74

    Expert Comment

    by:Jeffrey Coachman

    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.



    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now