Access Forms - Search a table and display results in Subform

I'll get right to the point...
I have a form that allows a user to enter info. If a duplicate record is trying to be submitted (based on 3 fields) the user is prompted to enter an ID (one of the 3 fields) into a combo box to search for any records with that ID. I want the results, there are most likely going to be multiple records, to be displayed in either a list box or maybe a subform. The user then must select one of those records, which will be displayed on the main form, allowing them to edit the record.
Is this possible?
Thanks in advance for your expert help and advice.
nysoscdesktopsupportAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
it is best that you upload a copy of your db.
0
Helen FeddemaCommented:
See my Simple Filters database for an example of filling a subform with data filtered by a selection in a combo box.  You could adapt it to your needs.  Here is a link for downloading it, and a screen shot of the form:
http://www.helenfeddema.com/Files/accarch160.zip
Simple-Filters-form.jpg
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Helen FeddemaCommented:
If you need to filter by three values, see my Fancy Filters database:
http://www.helenfeddema.com/Files/accarch129.zip
Fancy-Filters-Form.jpg
0
nysoscdesktopsupportAuthor Commented:
sorry, due to the content of my db I cannot upload a copy of it here.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.