Auto populate message in subform

[grant2684]

Hi,

I have a status combo box in the main form and would like to create a new note in a text field on the subform. The main form is called "Main" and the text field is called "FraudNotes".

Any help would be much appreciated.

Kind regards,

 

[TheAceMan1]

How ae ya grant2684 . . .

Not trying to sound this way or that, but, ask a [blue]vague question[/blue] ... [blue]get a vague answer![/blue]

A [blue]delicate[/blue] example of what your after is in order.

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[grant2684]

Hi,

To expand on this....

Basically, I have users who populate main form and choose a status (New, Pending and Completed) depending on the outcome. When the users has selected the outcome (after event), i would like a new auto note populated in a text field in a sub form. For example, if the status is "New", I would like a new note added stating along the lines of "Status has been changed to NEW".

A new note should be created in the sub form each time it has changed.

The main form is called "MainForm" (where the status field is) and the status field is called "Status".

The auto note should be populated in a sub form called "NotesForm" in a text field called "Notes".

Any help would be much appreciated.

Kind regards,

Grant

 

[PHV]

What have you tried so far and where in your code are you stuck ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[grant2684]

Hi,

I started writing a code as follows:

Private Sub Status_Change()
Me![NotesForm]![Notes] = "Status has been changed"
End Sub

This adds a note in the field, but only populates the first record, instead of creating a new one?

Sorry, I am a complete novice at this.

Any ideas??