Recent content by RitaG

  1. R

    Calculating with null values

    Pls help, very novice user here I have a check box called [8% Received]on a report that is referenced by a field called [8%Comm]. The expression for the [8%Comm]field is: =IIf([8% Received]=False,0,([CPremium]+[BPremium]+[OPremium])*0.08) This works just fine problem is - now I want the...
  2. R

    Dlookup

    Hi - Hope this add'l info helps. ClientID field has combo box from another table. Added after event to combo box under the event procedure. (data in combo box is text) Firstname field has Dlookup function in Property Control Source. Both fields are unbound. When I input a client ID it...
  3. R

    Another question on DLookup

    Thanks Jack for the help getting my Dlookup to work. I can now get it to fill in the name field automatically when I input the ClientID from a combo table. But .... I assumed when it entered the info it would become part of a permanent record & then I could go to a new record select a different...
  4. R

    Populate other fields from a combo box

    More questions - I tried and this didn't work for me. 1. the form I am creating has a combo box created from another table. When I try to enter data it tells me I have a macro error. I don't have any macros unless the after event entry is considered a macro. 2. Per someone elses suggestion I...
  5. R

    Dlookup - I think

    I have two tables ClientNames and Sample. ClientNames has two fields called ClientID and FirstName that I want to reference on the Sample form I am creating. On the Sample form I have a combo list of client IDs based on the ClientName table. When I enter an ID in the Sample form's ClientID...
Back
Top Bottom