Help needed to count of records from table to user form

Folks,

I have a Access 2010 database with a master table called "Radio_Main" with field "Condition".

Under "Condition" filed there are three records "Damaged", "Missing" and "Good Condition". Now I want to get Count of "Good Condition" records in TextBox1 on a user form called "R_Radio". Please help me to fix this issue.

Thanks in advance.

Joshi

Hi ranman256,

Oh great...Thank you so much for your swift response and help. Can you please help me to fix below issue.

In the same database and table I have a field called "Issue_Date", in this field some rows are filled with dates and some are null. Now I want to get the count of null in the TexBox2 and in the Textbox3 I want to get the value (TextBox1 - TextBox2).

Thanks in advance,

Joshi