Access Form Display Help

[prasadmng555]

Hi,



I am pretty much new to the MS Access 2010. I need some assistance from you guys.

E.g. I have table which has data of employees leaves.
I want to create a form which will display the data from the table by selecting a drop down/combo box in the form.

Assume. I have selected Peter as employee & it should display data from table relating to Peter only.

Can someone help me on this?

Many thanks,
Prasad.

[pbaldy]

One way:

BaldyWeb wherecondition

[prasadmng555]

Is it possible to do without writing any coding

[June7]

Unless you want to use the intrinsic Access tools from ribbon or right click shortcut menu, some code will likely be involved.

Alternative to opening another form is to apply filter to form already open. Have combobox in form header section.

Code can then set the form Filter and FilterOn properties,example: http://allenbrowne.com/ser-62code.html

Another method is dynamic parameterized query. This example is for text type fields http://www.datapigtechnologies.com/f...tomfilter.html

[pbaldy]

June7 will be taking over.