Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Auto populate message in subform
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??- grant2684
- Post #5
- Forum: Microsoft: Access Forms
-
Auto populate message in subform
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...- grant2684
- Post #3
- Forum: Microsoft: Access Forms
-
Auto populate message in subform
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,- grant2684
- Thread
- Replies: 4
- Forum: Microsoft: Access Forms
