Consulting

Results 1 to 3 of 3

Thread: Possible to have Calculated Field in Continuous Form?

  1. #1
    VBAX Regular
    Joined
    Feb 2018
    Location
    Portland
    Posts
    24
    Location

    Possible to have Calculated Field in Continuous Form?

    Hello, I have a continuous form with a calculated field that is generating a #Name? error. The control source =[RetailPrice] - [Cost]. This field displays just fine in a standard form showing only one record at a time but not in the continous form.

    Is this a limitation of continuous forms or is there something simple I am missing? I am aware that I could do the calculation in a query and base the form on a query but was just curious if I am missing something. A screenshot is below---Thanks for any help

    Continuous Forms Error.jpg

  2. #2
    VBAX Regular
    Joined
    Feb 2018
    Location
    Portland
    Posts
    24
    Location
    I meant to post this to the UtterAccess forum since this isn't a VBA question. My apologies. I have been using this great website so much for my VBA projects that I got on "autopilot".

  3. #3
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,188
    Location
    If you didn't get an answer on utter access the answer is yes you should be able to use a calculated field, in fact you can do a summation of values etc.

Posting Permissions

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