Creating a usefull data access page

Hi all,
Basically I'm an intern for an airline and I've been charged with creating this DAP within Access. I need to know how to create a search in the page to find a certain ID, then display some text corresponding to that ID. And I also need to display each case on an open or not basis from a drop down menu. I believe I need to make a macro command button for the search correct? The data is all based on a SQL server. Any and all help appreciated.

AFAIK, you can not use macros in a web page (DAP).

Are you wanting to run this in a web browser on a web server?