Notes/Observations forms

[MaliciousMike]

Hello...

I have 2 forms that are being bitches!

I have a main form that holds all the data entry info for records except "notes" (which is just general internal notes) and "Observations" (like "notes", but client friendly)

Instead of having the text boxes for these fields on the form, i created 2 buttons to open seperate forms for these records, simply to save room.

When the button is clicked, the openarg is the ID of the created record.
The notes and observation forms are supposed to open this record so you can enter notes in for this record.
Unfortunately, both forms are being bitches and creating new records. When i say "no additions" the forms don't show anything.

Private Sub Form_Open(Cancel As Integer)
Me.RecordSource = "SELECT Notes FROM Results WHERE Results.[ID]=" & Me.OpenArgs
End Sub


that's what i got and it wont work!

 

[ansentry]

Have a look at the attached same, I have made Notes and Observations Type - Memo.

Note the customer name appears on both notes and Observations when opened from the frmData.

If you want to close your form (same as my frmData) when either frmNotes or frmObservations is opened and then when they are closed return to the record and form you started from ,you would have to use OpenArgs.

 

[MaliciousMike]

Cheers.

I looked at your code and i slapped my head thinking "i'm so stupid!!"

Thanks.

 

[ansentry]

and now you feel better, but does the code work for you?