Windows Forum

Ask something
Discussion Locked

MS access 2000

0 helpful
2 replies

by kn_abhilash

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

hi

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

2 replies

by bristar

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!

This discussion is closed to new replies.