General discussion


MS access 2000

By kn_abhilash ·

i am using MS Access 2000 to create a small package

what i want is On Click of a Command button, it should find a record from the table( say test1)
from the given parameters

for example i have a table called test1
and files like, serial no, name, phone number , address

in a form, i will accept name and phone number
then on click of a command_button it should check the table test1 and return a value,

i want to do it through VB code editor

please help urjently

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by Bristar In reply to MS access 2000

You can do this through many different ways. One of the easiest is to create a sub-form in your form with the command button (you can hide it if you want until execution). Then have the code modify that form to filter down your selection criteria based on what was entered.

I use this now with a database of mine. I actually have a separate table with a single entry of a date. When I start my form, I set the date in that cell to yesterday's date. All of my subforms are set to filter based on the date in that table. All I have to do program a command button to change the date and requery and the information changes for me in the subform.

Let me know if you need an example to work from!

Collapse -

by kn_abhilash In reply to MS access 2000

thanks Bristar

if u can give me an example, it will be realy healpful

Related Discussions

Related Forums