Replies

Yes, the Form_frm_1_prod_line_input is the form running the code. I was not sure if DCount would use multiple sets of criteria for looking up the information. I had made those changes plus a couple more and I still get “Object variable or With block variable not set (Error 91).” Here is what I changed as well as adding the DAO in your suggetion.

Set rst = db.OpenRecordset(“SELECT prod_line, prod_line_date, prod_line_shift FROM 1_tb_prod_line_input WHERE 1_tb_prod_line_input.prod_line = ” & Me.c_prod_line.Value & ” AND 1_tb_prod_line_input.prod_line_date = #” & Me.prod_line_date.Value & “# AND 1_tb_prod_line_input.prod_line_shift = ” & Me.prod_line_shift.Value)

Out Standing, I was trying to use the cell value in stead of formula is, This is exactly what I was trying to figure out.
Thank You Very Much