jleval
asked on
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
<As I said before, we cant add anymore fields to the table>
I apologize, ...I missed that part...
Try this:
Access-EEQ27831568-AddChildRecor.mdb
I apologize, ...I missed that part...
Try this:
Access-EEQ27831568-AddChildRecor.mdb
ASKER
Exactly what I was looking for, Thank you
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
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
What's the reason why you can't add the notes on the main form itself?