Results 1 to 2 of 2
  1. #1
    gracysaurus is offline Novice
    Windows 7 Access 2007
    Join Date
    Jul 2010
    Posts
    2

    Use Combo Box to Populate Form

    I have a set of 5 forms, each providing student data for a different degree program. There is a sixth form, BasicInfo, which keeps track of contact information. I have the name fields from BasicInfo connected to the name areas of all the other tables, but now what I need is a combo box at the top of EACH form which allows me to select a name from the preexistent list of names and have the form fill in with the existing data so I can edit or remove pertinent pieces.



    I've tried many, many things.
    My most recent attempt:
    Code:
    Me.AllowEdits = True
    On Error GoTo ProcError
      DoCmd.FindRecord Me!cboFindRecord, acEntire, True, acSearchAll, , acCurrent, True
    ExitProc:
       Exit Sub
    ProcError:
       MsgBox "Error: " & Err.Number & ". " & Err.Description
       Resume ExitProc

    The code used to be as simple as:
    Code:
    DoCmd.FindRecord Me!cboFindRecord,acEntire,True,acSearchAll,,acCurrent,True
    but that didnt' work either.

    cboFindRecord is the name of the combo box, the fields in question are:
    BasicInfo.Last_Name
    BasicInfo.First_Name
    the primary key is BasicInfo.BasicInfoID

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    When one adds a combobox (in the header of a form) the wizard should launch and one of its choice is that the combobox be used to go to find a record for the form.

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

Similar Threads

  1. auto populate combo field?
    By myboii in forum Access
    Replies: 8
    Last Post: 07-09-2010, 05:46 AM
  2. using a combo box to populate fields then save
    By crazy1701d in forum Forms
    Replies: 2
    Last Post: 05-19-2010, 07:22 PM
  3. Use a combo box to populate a text field
    By niesenj in forum Forms
    Replies: 2
    Last Post: 01-29-2010, 01:57 PM
  4. Auto-Populate Combo box
    By vincenoir in forum Forms
    Replies: 3
    Last Post: 10-14-2009, 07:06 AM
  5. Populate Combo Box
    By wes28 in forum Programming
    Replies: 1
    Last Post: 03-04-2009, 06:45 AM

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