I have a subform that I would like to input new client notes. The two fields in the subform are date & notes. When I pull up the subform the previous notes are in the record. I would like to pull up blank record to input notes into. How do I go about doing this?
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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Subform - New record Notes
- Thread starter Adams
- Start date
One way:
place a button on the parent form
in the onClick event of the button put the following code:
If Me![YourSubformName].Form.DataEntry = True Then
Me![YourSubformName].Form.DataEntry = False
Else
Me![YourSubformName].Form.DataEntry = True
End If
Clicking the button will toggle your subform between the data view and the dataentry view. Replace YourSubformName with the name of your subform.
place a button on the parent form
in the onClick event of the button put the following code:
If Me![YourSubformName].Form.DataEntry = True Then
Me![YourSubformName].Form.DataEntry = False
Else
Me![YourSubformName].Form.DataEntry = True
End If
Clicking the button will toggle your subform between the data view and the dataentry view. Replace YourSubformName with the name of your subform.
- Status
Similar threads
- Locked
- Question
