How to retreive specific data from a database

[Guest]

Hi,

I have a employee database which contains all information pertaining to
their holidays/ leave taken. I've managed to create a form which allows the
employee to enter or rather submit their holiday form accordingly.Obviously,
over time the database will grow i.e. 1 employee may have many holiday form
submissions.

This being the case, I would like to know how I can retrieve the correct
data from the database and populate the form accordingly. From what I've read
so far, the possible solution would be to prompt the user for a crtieria to
be entered and subsequently retrieve the data from the database and populated
the rest of the fields in the form.

As I'm new to Ms Access, I'm not sure how I can do this ( it took me ages
just to create the form :-(. I believe there would be some programming
involved as such would appreciate examples.
Thanks.

 

[Madhivanan]

Let the user enter the keyfield
Then query
Select Columns from table where keyfield='value'
and disply the result accordingly

Madhivanan