Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using results in a different form.

Status
Not open for further replies.

Skinsella

Programmer
Feb 20, 2001
23
GB
Ok here's the situation. Some one types in their birthday in a TextBox called "txtBDay". What I need to happen is once they type in their Birthday and click a button a new form needs to appear which is just a small pop up with a single list box in it displaying all the names of the people who have their Birthday on the same day, once they pick a name that persons details are displayed on the previous screen.
For example, lets say I type in 10/08/66 in "txtBDay", I then click a button called "Get_Names". A new screen appears with a list of names who's birthdays are on the 10/08/66. I then click on a name eg Simon which causes the pop up screen to disappear, and taking me back to the original screen which now displays Simon's information ie his Date of Birth, address, phone number etc.
Make any sense to anyone? Help would be greatly received.
 
I have done something like this before... :)

The quickest way to do this is to have global variables (or a record perhaps) that will get all the info from the form that will display all the lists that matches the birthday that you typed. All you have to do is to reference the record/variable the presto!

Hope this one helps! jhonArmour
dolphinsoft@hotmail.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top