Search Box

[mandura]

hi folks,

i am trying to create something like an overview in access.

i have an imported excel table and i created a form.

no i want to add a search box. a simple box to type a artikle number
which is in the imported table.
if possible, i want to add a button to create a new entry, to add a articl and all the infos regarding to it. this information should be saved in the existing excel table.

no i can search with ctrl+find, but i dont like it this way because
you can very easy do something wrong (delete data, etc).

can anybody help me please?

thanks in advance!

mandura

ps: i am working for the first time in access and its pretty difficult for me.

 

[James Deckert]

see if this youtube helps you with the combobox lookup wizard
https://www.youtube.com/watch?v=EdH1aIWaD-0

 

[jdraw]

James,

Great video. What software are you using for the video?

 

[AccessBlaster]

It looks like he has "Camtasia" open.

https://www.techsmith.com/camtasia.html

 

[James Deckert]

Camtasia. Latest version