Ok, I am once again at your mercy =)
I have created a form whereas it is basically a main form with which I have created quick views.
I have a table that I has 6 fields
Ticket type, Name, IssueOfficer, startnumber, endnumber, Issuedate
I input and issue tickets based on a range of numbers. I input a ticket range of 100 to 1000 hence the startnumber and endnumber. I then turn around and issue 100 to 500 from the range.
What I am trying to do is create a search option in my main form that consists of type combofield, text field and the search button.
I want to be able to select a type from my type combo field then type in a number say 200 in the text field and once I click the search button it finds the following from the table
Name, IssueOfficer, (ticket range)startnumber, endnumber, Issuedate
Which is the record where that ticket type and number (200) fits within the ticket range.
Can anyone help me?


EB

__________________
EB

Hi,

   It is easy enough to use the combo wizard to look up values in the table Ticket Type field. Modify the query to show Unique Values = Yes. If this field is a foreign key, just look up to the foreign key table and bypass this table.

   Then add a text box to allow users to type in the start number. Is this going to be a range, or the actual start number? For example, if the user types in 200, do you want them to see ticket 200, or do you want them to see tickets 200 through 299? Or some other range. This is important.

   The button can open your report or form based on a query, and that query can take the value from the combo box in the query criteria, and then you can analyze and pass the value from the text box in your code (check for values, errors, select ranges, or select a single ticket, etc).

Can you provide the information?


mmcdonal