Creating form to display Detailed information (1 Viewer)

[nexustech]

Hi Guys & Gurus,

Firstly pardon my nonsense and novice exposure to Access it's just my first step in Access actually.

I am looking to create a form where if I put some information e.g 123 or ABC, it will display the complete detail of that product or thing.

I did this in excel but created a table and then VLOOKUP there. but since I am very new to accessing i don't know how it's done here.

I would appreciate all the support and help that can make this happen for me, please.

 

[Gasman]

On the premise that a picture is worth a thousand words, look in Youtube.

https://www.youtube.com/results?search_query=access+basic+forms

There are also plenty of other videos explaining other aspects of Access.

 

[Pat Hartman]

If you create a bound form and then add an unbound combo to the header, the wizard will build search for you.

 

[nexustech]

If you create a bound form and then add an unbound combo to the header, the wizard will build search for you.

Hi Pat , thanks for your message mate, you are soul saver. Real Gem,

Can you share some sample file for it

 

[Gasman]

Google 'allen browne search'

 

[Pat Hartman]

You're welcome Sometimes Access can actually be helpful.