Datasheet view, hyperlink to data entry form based on item type

I am creating a manifest datasheet form for data entry which records each item received such as an envelope, a courier package, a box etc. Which works great. We do, however, also receive a mail bin which can contain 100 items, and so I would like to be able to record the receipt of the mail bin in the manifest form, but then hyperlink to a related data entry form Only for items named mail bin.

I have seen hyperlinks for every field to a related form...can I be selective and only show a hyperlink if the item is a mail bin?
Bill NelsonITAsked:
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.

Typically you wouldn't use a hyperlink to do this.  A hyperlink is used to open a static document and you are not passing in any data.  When you open one form from another, you usually need to pass in the ID of the current record on the first form.

Use the double-click event of one of the fields.  You can set the format of the field so that it looks like a hyperlink so that it catches the eye of the user.  Then in the double-click event, you decide which form you need to open and either open formA or formB depending on some data value and using the Where argument of the OpenForm method, you can filter the form so that it shows only the selected record.

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
Bill NelsonITAuthor Commented:
Thanks very much for the excellent advice !

I will follow your advice and really appreciate you taking the time to help.

Hope you have an awesome day!

You're welcome :)
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.