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

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


"AP" <AP@discussions.microsoft.com> wrote in message 
news:B952CA9E-FCE4-473B-921F-011CE6972084@microsoft.com...
> 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!!



-- 
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Alex Dybenko" wrote:

> 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
> 
> 
> "AP" <AP@discussions.microsoft.com> wrote in message 
> news:B952CA9E-FCE4-473B-921F-011CE6972084@microsoft.com...
> > 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 
> 
> .
>