Results 1 to 4 of 4
  1. #1
    alexandervj is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2013
    Posts
    145

    RefreshRecord after updating ID Number?

    Hi,

    I'm having problems with the dialog window mode for opening a form (doesnt work on Firefox, wont work with a couple of the engineers computers because of the addons they have). So I have the form in a tab that they can click on and would like to have a input field at the bottom with the PartID number and once someone changes the PartID number the record refreshes and changes to that part number so they can edit it. How can I do something like this? I'm really just trying to bypass the Dialog window mode for opening a form. Thanks!

  2. #2
    Dal Jeanis is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Dallas TX
    Posts
    1,742
    1) Use VBA in the AfterUpdate event of the input field
    2) that should execute a requery or reposition of the form's record source.

  3. #3
    alexandervj is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2013
    Posts
    145
    hmm.. thanks for the reply, not exactly sure how to go about that though. Can you elaborate a little? Thanks

  4. #4
    Dal Jeanis is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Dallas TX
    Posts
    1,742
    To give specific instructions, I'll need to know how the form works now, and your initial post was vague on that subject.

    The form - does it have a table as its record source, or a query? Or, alternatively, is it unbound?


    If you don't know the answer to this, please describe what happens, scr3een by screen, as you open the database and navigate to the form that you have a problem with.

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

Similar Threads

  1. Replies: 3
    Last Post: 08-18-2013, 01:15 PM
  2. Replies: 6
    Last Post: 01-24-2013, 10:02 PM
  3. Replies: 0
    Last Post: 10-22-2012, 02:45 PM
  4. Replies: 6
    Last Post: 07-25-2011, 01:54 PM
  5. Making New Record Number Next Numerical Number
    By jhillbrown in forum Access
    Replies: 1
    Last Post: 03-10-2010, 11:06 AM

Tags for this Thread

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