Results 1 to 7 of 7
  1. #1
    aliup98 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Posts
    3

    ACCESS Novice Seeking Form Assistance


    I have recently created a database in Access 2010. I have created a form that populates several tables when saved. This is working properly to save new data to the tables. But when I use the form to search for a record to pull an individual record, the newly saved records are not searchable in the form. I'm sure I am missing something obvious but I have not been able to correct it. Any suggestions?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    How does one form populate several tables? Is this an unbound form or is it a form/subform arrangement.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    aliup98 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Posts
    3

    Unbound form

    Quote Originally Posted by June7 View Post
    How does one form populate several tables? Is this an unbound form or is it a form/subform arrangement.
    This is an unbound form.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    An unbound form has no records to be searched. Code saves data then code must retrieve data.

    Why using an unbound form?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    aliup98 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Posts
    3

    Novice

    Quote Originally Posted by June7 View Post
    An unbound form has no records to be searched. Code saves data then code must retrieve data.

    Why using an unbound form?
    Because I am a Novice, learning as I go. What would you recommend.

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Recommend bound form. Use Access intrinsic search, filter, navigation tools until you are ready to customize those functions with code.

    How are you saving the data entered on unbound form?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    rnodern is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    6
    I agree with June7.
    If you wish to update multiple tables with one form, an approach may putting multiple (bound) subforms onto your main form. Edit the data source in properties of the sub form to reference a unique ID from the main form. Remember, you need to be careful when addressing fields on another form or control.
    It's probably not the best practice way, but say for example, in the context of my main form, i want to address a field on the subform:
    [Forms]![frm_Main]![sub_Form]![Control]
    for a better description, see:
    http://access.mvps.org/access/forms/frm0031.htm

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

Similar Threads

  1. need assistance on image size in access
    By paulkimball in forum Reports
    Replies: 0
    Last Post: 05-16-2012, 10:01 PM
  2. Replies: 2
    Last Post: 01-26-2012, 08:28 AM
  3. Replies: 3
    Last Post: 09-16-2011, 10:09 AM
  4. Form Combo Box assistance for Novice
    By piper in forum Forms
    Replies: 1
    Last Post: 04-22-2011, 12:53 AM
  5. New to Access - Looking for some basic assistance
    By Dave_EntryIT in forum Access
    Replies: 2
    Last Post: 03-27-2011, 11:25 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