D
DS
This DLookUp Statement is giving me problems. The are all number
fields except the last field. I think that it's the last field which is
an F that is the culprit.
Me.TxtGroup = Nz(DLookup("GroupID", "tblInfoGroup", _
"tblInfoGroup.TerminalID = " & Forms!frmOrderScreen!TxtOSStation & " " &
_"AND tblInfoGroup.DayID = " & Forms!frmOrderScreen!TxtOSDay & " " & _
"AND tblInfoGroup.MenuID = " & Forms!frmOrderScreen!TxtOSMenu & " " & _
"AND tblInfoGroup.MenuCatID = " & Forms!frmOrderScreen!TxtOSSection & "
" & _
"AND tblInfoGroup.ItemID = " & Forms!frmOrderScreen!TxtOSItem & " " & _
"AND tblInfoGroup.GroupLevel = " & Forms!frmOrderScreenForce!TxtLevel &
" " & _"AND tblInfoGroup.GroupAction & " = F), 0)
Thanks
DS
fields except the last field. I think that it's the last field which is
an F that is the culprit.
Me.TxtGroup = Nz(DLookup("GroupID", "tblInfoGroup", _
"tblInfoGroup.TerminalID = " & Forms!frmOrderScreen!TxtOSStation & " " &
_"AND tblInfoGroup.DayID = " & Forms!frmOrderScreen!TxtOSDay & " " & _
"AND tblInfoGroup.MenuID = " & Forms!frmOrderScreen!TxtOSMenu & " " & _
"AND tblInfoGroup.MenuCatID = " & Forms!frmOrderScreen!TxtOSSection & "
" & _
"AND tblInfoGroup.ItemID = " & Forms!frmOrderScreen!TxtOSItem & " " & _
"AND tblInfoGroup.GroupLevel = " & Forms!frmOrderScreenForce!TxtLevel &
" " & _"AND tblInfoGroup.GroupAction & " = F), 0)
Thanks
DS