adding notes form

[Guest]

Hello,

I am trying to do the following:

I have a notes table, and a doc input table. I then have a form for the
document input and have a second form for the notes input. All notes are
related to the record in doc input table. When entering a new doc using the
doc input form, there is a button that is used to open the notes form to
enter notes regarding the record just entered in the doc input form. I would
like to have the notes linked to their individual record in the doc input
table. I have tried to link using a query lookup of the docID, however that
has not worked. I have also tried to have the notes in the same table as doc
input but simply have a second form but that has not worked either.
Basically rather then having hte notes on the same form as teh doc input, I
want to have a second form for this type of information. I'm wondering if I
am going about this the right way, or if there is an easier to do this.

Sincerely,

 

[storrboy]

Hello,

I am trying to do the following:

I have a notes table, and a doc input table. I then have a form for the
document input and have a second form for the notes input. All notes are
related to the record in doc input table. When entering a new doc using the
doc input form, there is a button that is used to open the notes form to
enter notes regarding the record just entered in the doc input form. I would
like to have the notes linked to their individual record in the doc input
table. I have tried to link using a query lookup of the docID, however that
has not worked. I have also tried to have the notes in the same table as doc
input but simply have a second form but that has not worked either.
Basically rather then having hte notes on the same form as teh doc input, I
want to have a second form for this type of information. I'm wondering if I
am going about this the right way, or if there is an easier to do this.

Sincerely,

I think the problem might be that when adding a new record, it doesn't
really exists until it is committed to the table. Opening a second
form and trying to add or relate information to a record that is not
there isn't possible. In one application I worked on we had the same
issue. We chose to place the notes in the main table, even though that
field may or may not be used. A hidden text box was placed on the main
form and a button opened a pop-up for the user to enter notes. This
pop-up referenced the textbox on the main form and the notes were
transfered between them. This way a new record could have all info
committed at the same time. We chose this route due to the number of
controls on the main form, it made sense for us to but a notes box
outside of it. If you have space on your main form, I would place it
there just to make things simpler. Perhaps a tab control to separate
the controls would work in your case.

 

[Guest]

I like the popup idea with the hidden txt on teh main form, however other
then adding the hiddentxt field and making it hidden, and creating my form
and making it a popup, I have no idea how to relate the two together. Is
this something you can go a bit more into details with me?

Thanks for your help!

Jean-Francois Gauthier

 

[storrboy]

I like the popup idea with the hidden txt on teh main form, however other
then adding the hiddentxt field and making it hidden, and creating my form
and making it a popup, I have no idea how to relate the two together. Is
this something you can go a bit more into details with me?

Thanks for your help!

Jean-Francois Gauthier

If the two are always used together then it's simple. Replace control
and form names where appropriate
Adding other functionality like enabling/disabling/locking controls,
validation etc. would need to be added on top of this. Watch for line
wrapping...

In the pop-up form's Open or Load event:

Me!TextBoxForNotes = Forms("MainFormName").HiddenTextBox

In it's Close or Unload event

Forms("MainFormName").HiddenTextBox = Me!TextControlForNotes

 

[John W. Vinson]

if there is an easier to do this.

Yes. Make the Notes form a Subform of the Docs form.

If you need space on the screen, you can use a Tab Control - put your
main form controls on one page and the subform on the second page.

John W. Vinson [MVP]

 

[Guest]

I think we would rather have it as a popup form as it is an option to use,
but not mandatory, therefore if its not needed, we don't want the user to see
it unless he clicks a button and has the form pop up.

 

[John W. Vinson]

I think we would rather have it as a popup form as it is an option to use,
but not mandatory, therefore if its not needed, we don't want the user to see
it unless he clicks a button and has the form pop up.

How is that different than the user having an optional tab on a Tab
Control (which can even be made to appear on screen as a button, if
you wish; that's one of the options for a Tab)? If it's not needed,
they don't need to select the tab.

If you DO want a popup form you'll need two bits of code: one in the
OpenForm method to set the WhereCondition argument *and* to pass the
current DocID in the OpenArgs argument; and code in the notes form's
Open event to set the DefaultValue property of the DocID.

John W. Vinson [MVP]