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

[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

 

[Alex Dybenko]

Hi,
not clear what you need. You can populate textbox with text data, in order
to show several records - you can use listbox or form in datasheet or
continuous view

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[ryguy7272]

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!!