Dlookup won't work

[Djblois]

I am using this dlookup and it is not giving me any errors but it is returning nothing. Why won't it work?

DLookup("[Whse]", "tblWhse", "[WhseID] = " & Form_SubfrmAppts.cobCarrier.Value)

I know the value is there.

 

[pbaldy]

Is SubfrmAppts a subform, as its name implies?

http://www.mvps.org/access/forms/frm0031.htm

 

[Djblois]

yes it is a subfrm. But I am not accessing it in the parent form. I am accessing it in code underneath itself.

 

[pbaldy]

Doesn't matter.

 

[Djblois]

Here is the full code. I changed it like you suggested in the code and I still am getting a blank.

Form_frmDelete.lblError.Caption = "Are you sure you want to delete Apptointment CW" & _
            Form_frmScheduled_Appts.tbConfirmation.Value & " With Carrier " & _
            DLookup("[Whse]", "tblWhse", "[WhseID] = " & Me!cobCarrier) & _
            " and remove all of it's associated Orders from WST?"

 

[pbaldy]

Is the control named "cobCarrier" really returning a value for WhseID? Those look incompatible (Carrier vs Whse). Can you post the db?

 

[Djblois]

Please don't yell. I am a total idiot!! lol brain fart. I was just doing something with the warehouses - you are right I am looking in the wrong table. lol

 

[irish634]

I assume your command button is on the parent form. In this case it would be:

Me!Subform1.Form!ControlName

 

[pbaldy]

When you've made as many bonehead mistakes as I've made, you don't yell at others.

Glad you sorted it out.

 

[SOS]

When you've made as many bonehead mistakes as I've made,

Please tell me that they start coming at longer intervals. There are times I start to wonder if the frequency will start to decline for me.

 

[pbaldy]

Okay...they start coming at longer intervals.

It may not be the truth, but it is what you wanted to hear.

 

[SOS]

It may not be the truth, but it is what you wanted to hear.

Thanks - ignorance is bliss they say