Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2013
    Location
    Chesapeake, VA
    Posts
    30

    Unanswered: Anyone available to help with a form ?

    Hi, I'm hoping someone can help me figure out how I can get this form to reset fields correctly and prepare for the next data entry.

    I have a form that is opened in the "add" mode using the switch board:

    For some reason, fields are not clear upon completing the form or entering
    the form. The form keeps letting me tab through the fields. I thought using the add mode of the SB would handle this automatically.

    I tried adding some code after update in the form:

    Code:
    Me.cboAssets_ID.Requery
    Me.Requery
    But still can not get to clear and reset. Any suggestion would be greatly appreciated.

    Thank you

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    off top of head

    Just do a DoCmd.GoToRecord that should clear the screen

    in the properties there a setting to loop current record or page (play with that to)



    DoCmd.GoToRecord , , acNewRec
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Are you sure that this Form is actually Bound? The behavior really sounds like an Unbound Form.

    Linq ;0)>
    Hope this helps!

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

    All posts/responses based on Access 2003/2007

  4. #4
    Join Date
    Jan 2013
    Location
    Chesapeake, VA
    Posts
    30
    The forms Properties "Record_Source" shows that it is bound to the Materials_Assignment table as it is supposed to be.

    I do however, have an unbound combobox in the form. Otherwise, Everything is working OK its just that only the comboBox and date fields clear. All of my text boxes move to the data of the next record. I have tried just about everything.

    What I want it to do is exactly what the switch board does each time the form is opened.

Posting Permissions

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