search form 1

[chaosguy]

Hey guy, I wanna design a search form where the user would select a field they wanna seach from "txtField" and then enter the information they wanna search for "Txtdata". They would then hit the generate button, so that the program would search through the query for that information, when it find it, i have another form called search result that i wanna pop up and show the information that the customer was looking for. I have already created the search result form which I based on the query.

Does anyone know how I can do this?

In python it would be somthing like:

if field == "Customer ID":
for txtdata in field:
open search result with txtdata
print "Record not found"
elif field == "Order ID":
for txtdata in field:
open search result with txtdata
print "Record not found"
elif field == "":
print "you must enter a field to search in"

that's basically python, well it would be psuedocode actually cause i wrote it wrong, but i wanted u to sort of follow what i mean.

Can anyone help? The search result isn't suppose to open if there is no record that fits the criteria. yeah
I guess this would be real hard to do considering that I ahve no idea where to start :S. anyone?


Chaosguy - To die would be an awefully big adventure.

 

[PHV]

To get some ideas:

http://download.microsoft.com/download/access2000/Sample/1.0/WIN98Me/EN-US/Qbf2k.exe

http://www.mvps.org/access/modules/mdl0056.htm

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886