ID search Query

[clarkej]

hey need help again,



got my self a little stuck on a problem

Background: have a table showing several offices, and in each office there are several staff members ( natually, before i get a funny comments )

i have a form that using a query to display regions of the offices and displaying results into a datalist. what i then want it to do is open all the staff details in another form based on the office that is selected.

My problem is im not to sure how to set the querey up so it responds to the selected Office ID and search for that ID in the Staff table to find the correct staff???? would perfer it to be "open on click" to open the form but how do i set it up to search that??

thanks
Jay

[RuralGuy]

It really depends on what else you might need but here's one possible solution: http://www.baldyweb.com/wherecondition.htm

[clarkej]

It really depends on what else you might need but here's one possible solution: http://www.baldyweb.com/wherecondition.htm

thats worked thank you very much, took a wee while to get it just right but it dose what i want it to now

RuralGuy you ROCK!!

thanks again

Jay

[RuralGuy]

Great! Glad we could help.