Switchbord and forms...

[isaacalves27]

I want to do something that i dont know if it is possible: I would like that my Form just showed me the records that have on one field the value that i press on the text of the switchbord button (this value is always on the same collumn). So that just with one form or two i could navigate thrue all my records.

for es. Pressing on switchbord "Swedish" it would open my form and select just the records that have "Swedish" on Nationality.

Is this possible? Cause other wise the only way i lnow how to do this is to create a form to sweden, than one other to danmark etc... at the end i will have lots of forms, and each one of them will be used just to max 10 records.

Thanks for ur help

 

[ansentry]

isaacalves27,

I would suggest that you don't use buttons for each country as each time a new country was added to you database you would have to add another button.

Have a look at my sample, it may give you come ideas.

 

[isaacalves27]

Thanks this helped me a lot!!!!

 

[isaacalves27]

OK but..

Thanks this helped me a lot!!!! But I am still wondering if it is not possible to the thing i described. Because I am sure that the 'number of countries will not grow, because we just work on these countries. But is it possible to pass the information u give when u press the word :"sweden" so that it is used by the query??
Thanks anyway!

 

[isaacalves27]

Thanks for ur help!

 

[ansentry]

Here it is, Hope this is what you wanted.

Thanks for the thanks (3 times)