Results 1 to 4 of 4

Thread: Forms: Requery

  1. #1
    Join Date
    Sep 2005
    Posts
    313

    Unanswered: Forms: Requery

    Hello:
    I have a question. When I open 2 forms, they are related each other.
    The two forms will NOT be closed, but still update each other.
    When I enter one data in one form, and I want to select the value from the combox in another form, the value (I just enter the data) doesn't show.

    Form 1:
    add a value
    ACC

    Form 2:
    combox: Acc (doesn't show up)

    Can I use requery command to do it. Because I don't want to close the forms and then open them again, please let me know. Thanks.

  2. #2
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    Yes. Use the Forms collection to get to the combo box:

    Forms("NameOfForm").Form.Controls("ComboBoxName"). Requery

  3. #3
    Join Date
    Sep 2005
    Posts
    313
    Where do I put the sentence?

    Where do I find the Forms Collection?

    Please let me know, thanks.
    Last edited by accessman2; 09-20-05 at 17:48.

  4. #4
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,418
    Provided Answers: 7
    A Cheap Work around is

    close it first then open
    DoCmd.Close acForm, "This"
    DoCmd.OpenForm "This"

    there a quick screen flash
    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.

Posting Permissions

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