Link to home
Start Free TrialLog in
Avatar of thandel
thandel

asked on

Dlookup returning null

I have a table tMHFrame and in that tabel is a string for "Frame".  A value of frame could be something like "Rikki A12*" or "Rikki A12"

A user selects a frame from this table but on the form the only part of the model is used and the reset is stipped to only use the value of "Rikki" and drop the remaing "AXXXXX" values.

I would like to see if a user entered value (dFrameModel, which in this case would be "Rikki" ) is also in the table AND if that value in the table contains an "*" at the end.

This Dlookup is always returning null.  Any idea why?  So I'm basicaly trying to search in the table for "Rikki*" & "*"

sTest = DLookup("Frame", "tMHFrame", "Frame='" & dFrameModel & "*'" & "" * "")
ASKER CERTIFIED SOLUTION
Avatar of mbizup
mbizup
Flag of Kazakhstan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial