Results 1 to 4 of 4
  1. #1
    DanW is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Oct 2009
    Posts
    30

    Bound controls "mis"behaving

    When I open a form I would like the bound controls to be unpopulated until after I choose the appropriate record.

    What I am getting is the bound controls populated with the data from the oldest record, lowest autonumber, in the linked table. Very unprofessional effect to always have the same person's data show up whenever the form is opened.



    Appreciate the help, Dan

  2. #2
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows XP Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    Dan

    What would you like to happen?

  3. #3
    DanW is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Oct 2009
    Posts
    30
    I would like the bound text box controls to be blank until I select a record in my combo box.
    Last edited by DanW; 11-16-2009 at 11:07 AM. Reason: added text box

  4. #4
    DanW is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Oct 2009
    Posts
    30

    Solved

    I was having trouble putting the right words into search, but found the answer.

    For anyone else, this event worked for me.

    Private Sub Form_Load()
    DoCmd.GoToRecord , , acNewRec
    Me.comboboxname.SetFocus

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 21
    Last Post: 06-03-2009, 05:54 PM
  2. aSTR = Dir("C:\*.*") >> "Type Mismatch"
    By JGrant in forum Programming
    Replies: 1
    Last Post: 03-28-2009, 05:17 AM
  3. Export to .rtf of "104-" converts to "-655&qu
    By Sherri726 in forum Import/Export Data
    Replies: 0
    Last Post: 12-19-2006, 03:16 PM
  4. Replies: 2
    Last Post: 08-31-2006, 12:19 PM
  5. "Count" and "Countif" in Reports
    By JMantei in forum Reports
    Replies: 1
    Last Post: 06-20-2006, 02:20 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums