Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    58

    Unanswered: Reference field in combo box value

    I have a combo box that has various statements that when selected copy on to the end of the value in a memo field. What I want to be able to do is to reference a different field on a form in one of these statements. Eg: a statement in the combo box says something like "<<FORENAME>> has worked very hard this year." when this statement is selected the database should look to see what value is currently being shown in the Forename field and the value copied to the memo field should read "Bob has worked...". The 'FORENAME' reference does not always come at the start or the end of the statement.

    Is this possible?

    I tried using the replace function on the after update option of the combo box
    Replace([Comment],"<<FORENAME>>",[ForeName])
    but kept getting 'Compile Error: Expected: ='

  2. #2
    Join Date
    May 2004
    Location
    Moscow, Russia
    Posts
    29

    re

    variable = Replace(.....

  3. #3
    Join Date
    Jan 2004
    Posts
    58
    Quote Originally Posted by alexeyK
    variable = Replace(.....
    I tried adding a variable but now get the error message: Compile error: Sub or Function not defined

Posting Permissions

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