Input a value in a form and display in a report

Sep 6, 2011
Reaction score
hi all
new to forum as well as to Access. I have created a small database and have a form to add, view and edit records. but i need to query the table based on the user input

I have a form , i will have a text box and if the user types a name and press the button , it has to fetch set of records , in the form of report

the basic sql will be like this
Select Memberno, Firstname, Secondname, role, Meetingno
from Meeting
where memberno = 35566

in the above query the value 35566 will be input by the user

can you guys guide me how to achieve this ?

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question