Program Code Needed to open a form and select record.

[Guest]

I currently have a form with an unbound text box that I use to search the
database for the entered record. For instance, I typr 12345, press [Enter]
and it finds 123-45 as I want it to. I want to add multiple records with
similar part numbers: Example:
01130
01-130
0-1130
011-30
I would like to type all numbers as stripped (01130) and find a record CROSS
for multiple references that I have created and stored in a table for every
multiple. I need a form that opens and displays the other values above. I
then want to select the desired record and have it find my selection. Can
anyone PLEASE help me?

 

[John Nurick]

Which bit of this is giving you trouble? If you can type
12345
and have the database find
123-45
I'd have thought you'd be most of the way there.

I currently have a form with an unbound text box that I use to search the
database for the entered record. For instance, I typr 12345, press [Enter]
and it finds 123-45 as I want it to. I want to add multiple records with
similar part numbers: Example:
01130
01-130
0-1130
011-30
I would like to type all numbers as stripped (01130) and find a record CROSS
for multiple references that I have created and stored in a table for every
multiple. I need a form that opens and displays the other values above. I
then want to select the desired record and have it find my selection. Can
anyone PLEASE help me?

 

[Guest]

I believe I am getting there. In the past, I was not dealing with multiple
numbers of the same numeric pattern(no duplicates). So I thought, I might
have the the number (11030) find the reference CROSS which would trigger the
new form to pop up and display the multiple values that I could select from -
then close the pop up form and display the selected number on the main form.

Which bit of this is giving you trouble? If you can type
12345
and have the database find
123-45
I'd have thought you'd be most of the way there.

I currently have a form with an unbound text box that I use to search the
database for the entered record. For instance, I typr 12345, press [Enter]
and it finds 123-45 as I want it to. I want to add multiple records with
similar part numbers: Example:
01130
01-130
0-1130
011-30
I would like to type all numbers as stripped (01130) and find a record CROSS
for multiple references that I have created and stored in a table for every
multiple. I need a form that opens and displays the other values above. I
then want to select the desired record and have it find my selection. Can
anyone PLEASE help me?