B
Bill Phillips
I have data that I cannot validate upon entry. After
validation I have some records left that I need to
identify. I have form (frmNeedToID)that has an item field
and a location field that I can use to find a valid
record. I can compare these in 4 different ways to
identify my record. I am using a group box to choose how I
will compare the items. After selecting the group I have a
command button to run a macro that calls the appropriate
form for my comparison. This form takes the value and
finds all matching records in a list box. The list box has
3 fields in it, including an ItemID field. What I would
like to be able to do is to double click the correct
record and have it replace my ItemID field on my original
form (frmNeedToID). I know I'll need to do some coding,
but I'm not certain how to accomplish the task.
validation I have some records left that I need to
identify. I have form (frmNeedToID)that has an item field
and a location field that I can use to find a valid
record. I can compare these in 4 different ways to
identify my record. I am using a group box to choose how I
will compare the items. After selecting the group I have a
command button to run a macro that calls the appropriate
form for my comparison. This form takes the value and
finds all matching records in a list box. The list box has
3 fields in it, including an ItemID field. What I would
like to be able to do is to double click the correct
record and have it replace my ItemID field on my original
form (frmNeedToID). I know I'll need to do some coding,
but I'm not certain how to accomplish the task.