populate a text box with multiple records based on combo box selec

  • Thread starter Thread starter AP
  • Start date Start date
A

AP

Hi,

I have made one form with a combo box (dropped down) , a search button and a
Text box. when a user selects a value (ie. Project No.) and click on search
button the text box should display all the records which is related to that
Project no. The search record should display Drawing no., description , date
created etc. in a datasheet view from the table "Drawing details". the
searched result can be one or more.
can anyone help me with the code. How to search records and display it in
text box.
Thanx

AP
 
AP, I think you should look at this ComboBox example:
http://www.fontstuff.com/access/acctut17.htm
http://www.fontstuff.com/access/acctut17a.htm

At the bottom of the second link, download and run the file named
‘AccessAndSQL4_2000.zip’


Here’s something similar, but it uses a ListBox:
http://www.fontstuff.com/access/acctut18.htm

Go to the bottom of that page an download this file, ‘AccessAndSQL5_2000.zip’

One more example here, with a Report:
http://www.fontstuff.com/access/acctut19.htm

At the bottom of the page, you will find a file named,
‘AccessAndSQL6_2000.zip’. Download and run it and see what that does.

Good luck!!
 
Back
Top