Returning a Null Value

[gary.newport]

I am using the following to place data from a given field into the defined textbox, called txtBreakNo:

txtPrimary.Value = txtPrimary.ItemData(0)
        txtBreakNo.Value = DLookup("intBreakNo", "tblActivityStaffDate", "WeeklyActivity_ID" = txtPrimary.Value)

The field txtPrimary reports the correct value (from the test side I would be expecting a value of 44 and that is what I am getting), but I get a Null value.

The field name and the table name are correct so where am I going wrong?

 

[pbaldy]

The equals sign needs to be inside the quotes, I believe.

 

[gary.newport]

You believe correctly!

Thanks ever so much. It was being one of those programming events where I could not see the obvious.

 

[pbaldy]

It happens to us all; glad it worked for you.