Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amitbadgi
Starting Member
29 Posts |
 Posted - 2005-07-06 : 17:27:34
|
| Hi, I have created 5 forms, out of which theere are four forms for 4 different cities, I have wriiten a query for each of the form(excluding teh 5th), and each city has 2 access database tables, now I have created a 5th form where in if I enter a ID(of city1 say) and hit the search button in teh form it should be directed to city1's form, if i type in a ID of city2, then it shld be directed to city2's form and so on. Hence when i enter a ID it shld get compared to the ID's in the tables of the different cities and on clicking search it shld take me to teh corresponding citys form. How do I do it, any suggestions are appreciated. Thanks |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-07-07 : 01:05:24
|
Not sure why you have this requirementThis may help youIf trim(txtcity.text)="City1" thenform1.showelseIf trim(txtcity.text)="City2" thenform2.show..end if Hereafter post your question at relevent forums  MadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
how to jump to another form in access