Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    California, USA
    Posts
    25

    Unanswered: Calling A Private Function From A Public Function

    I have a public function that inserts a selected record from one table to another table; however, on the Main Form there is a calculated field that needs to be activated by some event. Since the update is done directly into the main table, there is no event to work with.

    I've been trying to find a way to get the calculated field to work inside the public function that inserts the data. Has anyone come across this type of problem?

    Thanks,
    PC

  2. #2
    Join Date
    Feb 2004
    Posts
    533
    Quote Originally Posted by PC User
    I've been trying to find a way to get the calculated field to work inside the public function that inserts the data. Has anyone come across this type of problem?

    Thanks,
    PC
    Forms("frmName").Recalc

    If that does not work

    Forms("frmName").Requery

    Will update the form and any calculated fields.

    ~
    ~

    Bill

Posting Permissions

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