Results 1 to 9 of 9
  1. #1
    Join Date
    Jul 2006
    Posts
    6

    Unanswered: Update Underlying form

    need help in just these couple of issues:

    1. In the same project, which has a form "ENTRY FORM" I have used the
    fields [invqty], [invprice], [invval], [poqty], [poprice] [poval], where
    invval = invqty * invprice.....poval = [poqty]*[poprice].....
    I am able to calculate the value, however, the invval is not displayed on the
    form unless I save the record. How can I make this work so that I dont need
    to exit the record and come back to check the invval. Please help.

    2. On the same form, i have field for [STYLE], which looksup for a value from
    the STYLE table. I have enabled a macro to open the [STYLE MASTER] Form when
    NOT IN LIST. However, after adding the style in the master, It still does not
    become available until I save the underlying record on the "ENTRY FORM" and
    reopen it. So every time a new style is added, I have to close the form and
    reopen it to enter the style. Can you please help.

    Thank you..

  2. #2
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    And pray tell ... why is this in the SQL Server Forum? SQL Server does not have forms.

    -- This is all just a Figment of my Imagination --

  3. #3
    Join Date
    Jul 2006
    Posts
    6

    Update Underlying form

    need help in just these couple of issues:

    1. In the same project, which has a form "ENTRY FORM" I have used the
    fields [invqty], [invprice], [invval], [poqty], [poprice] [poval], where
    invval = invqty * invprice.....poval = [poqty]*[poprice].....
    I am able to calculate the value, however, the invval is not displayed on the
    form unless I save the record. How can I make this work so that I dont need
    to exit the record and come back to check the invval. Please help.

    2. On the same form, i have field for [STYLE], which looksup for a value from
    the STYLE table. I have enabled a macro to open the [STYLE MASTER] Form when
    NOT IN LIST. However, after adding the style in the master, It still does not
    become available until I save the underlying record on the "ENTRY FORM" and
    reopen it. So every time a new style is added, I have to close the form and
    reopen it to enter the style. Can you please help.

    Thank you..

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Is this an MS Access front-end? We can move the thread there for you.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Not many details here ... Form bound to a table? Form single entry or continuous? Data is entered in how? What controls are used? Your example, is it a new record?

    Your 2nd question: Try Requerying the combo after the add ...
    Back to Access ... ADO is not the way to go for speed ...

  6. #6
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    For #1 try the command:

    DoCmd.RunCommand acCmdSaveRecord

  7. #7
    Join Date
    Jul 2006
    Posts
    6
    Would you please move it as this is a MS Access front end and SQL back end.

    Thank you.

  8. #8
    Join Date
    Jul 2006
    Posts
    6

    Thanks it worked

    Thank you,

    the requery worked for the first and the save worked for the first.

    Appreciate your help...

  9. #9
    Join Date
    Jul 2006
    Posts
    6
    In fact the requery worked for the 2nd.
    Thanks

Posting Permissions

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