Check Box Problem

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • E Thoemmes
    #1

    Check Box Problem

    Hi

    I have a table which is imported from an accounting system, the table
    has a field called PurBlock. If there is an x in the field there is a
    block on the record. I have based a form on this table and would like
    a check box to indicate if there is a block on the record. I tried
    using =IIf(tblVendors !PBloPurOrg="x" ,-1,0) but this doesn't work.

    Can anyone help?

    TIA
    Tags: None
    • Alan Webb
      #2
      Re: Check Box Problem

      E Thoemmes,
      If the form is bound to the table then no code is needed.

      "E Thoemmes" <edgar.thoemmes @boiukfs.co.uk> wrote in message
      news:1c0dd456.0 502230716.a3928 62@posting.goog le.com...[color=blue]
      > Hi
      >
      > I have a table which is imported from an accounting system, the table
      > has a field called PurBlock. If there is an x in the field there is a
      > block on the record. I have based a form on this table and would like
      > a check box to indicate if there is a block on the record. I tried
      > using =IIf(tblVendors !PBloPurOrg="x" ,-1,0) but this doesn't work.
      >
      > Can anyone help?
      >
      > TIA[/color]


        Comment

        Previous template Next
        Working...