DLookUp With Date Criteria Error

[Nadine67]

Hello and thank you for any attention my post may receive.

On my userform I have three fields – cboUID, txtComm andtxtID.

2. cboUID - number field.
3. txtComm - date field with Control Source ‘=DateValue(DMin("[Date_Commissioned]","qryUnit","[Unit]=" & [cboUID]))’.
4. txtID – Control Source is ‘=CSng(DLookUp("ID","tblUnit","[Unit]=" & [cboUID] & " And [Date_Commissioned]=#" & [txtComm] & "#"))’.

txtComm is not visible because it is purely a ‘helper’field.
txtID is not visible because it is also a helper field thatis used to open another form to the correct record.

I select a number in cboUID, txtComm populates with thecorrect date value, however txtID returns #Error…..and I have no idea why!



Any advice would be greatly appreciated!

 

[Nadine67]

Please ignore this post as it was posted in error!

Sorry for any inconvenience!