Results 1 to 2 of 2
  1. #1
    Join Date
    May 2012

    Unanswered: make the blanks null

    There is a form with some blanks and combo boxes. When I click the “record command” the data is recorded in table1. Then, the blanks whose “control source” is a field in table1 are cleared, while others with no “control source” are still showing the previous data.
    I would like to know if it is possible that all the blanks and comboboxes are changed to null after the “record command” is clicked.

  2. #2
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    You need to set each Unbound Control to Null when you move to the New Record:

    Me.UnboundControlName = Null

    Linq ;0)>
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts