Recent content by gashokkumar4u

  1. G

    Dcount as control for text box

    Thank you all! I can cable to get the correct count now.........
  2. G

    Dcount as control for text box

    Thanks for the advise! If I tried with "Alex" I'm getting the result, but I have only one processor form and getting the Alex count to all other when there is a processor name change. Can't it be changed automatically when there is a processor change in the field. I have total 4 processors...
  3. G

    Dcount as control for text box

    Thanks for replying! Sheet1 is the Table and Status & Processor are the fields in the table. Also, these Status and Processor are available on the form. Status value always remain same, but processor value change. For Example: Status = YTB, Processor = Alex, Xing, Chan If Alex has 10...
  4. G

    Dcount as control for text box

    Hi, Can anyone help on the below Dcount code as we are receiving an error or ?Name??:banghead: =DCount("[STATUS]", "sheet1", "[PROCESSOR] = '" & Me.Text57 & "' AND [STATUS] = 'YTB'")
See more
Back
Top Bottom