Creating a search function

[jlclark4]

I am trying to be able to search by a person (which this person has multiple entries) and it brings up a list of all the entries dealing with that person. I assume this needs relationships built between the list of names and the main table correct? Also, how do I get this to work? I have the initial window set up where you either click add new record or search records. I would like the search records to be different then the form that comes up with new record. Someone types in for example my name: Jennifer; and all the records that I have entered pop up in a box below. Then they can select which record they want to work on ... click, and the form that normally would open (the one with all the data in it) pops up for that corresponding entry... how can I do this? If I can get some hints, I should be able to figure it out...

[ajetrumpet]

i found the attached on my hard drive, and it might be able to help you out. I think the code probably does what you're trying to do...or close.

[jlclark4]

Yes, that example does help. But, how can I get the information into a datatable instead of a form (the sub information) and be able to access the main form they are pulled from by clicking on a record. Could I in turn keep what you have but add a button thats like view this record and it will open up the entire record in a new window?

[ajetrumpet]

Yes, that example does help. But, how can I get the information into a datatable instead of a form (the sub information) and be able to access the main form they are pulled from by clicking on a record. Could I in turn keep what you have but add a button thats like view this record and it will open up the entire record in a new window?

one of the buttons on that sample opens a new form window with only the clicked record, Jennifer. Did you see that?

[jlclark4]

Yes, I played with it some. It had "open new form" as its label and it threw me off. Thanks for the help!

[ajetrumpet]

no problem.

pls mark the thread solved via 'thread tools' if it is ok?

[Ashe]

I have a follow-up question to this: How could it be programed to clear itself? For instance, a user has searched the records for "person2" and now all the orders associated with person2 are displayed. I would like to put a button on a similar form that refreshes the form to have no records displayed and all combo boxes clear. I already have the combobox=null settled, I just need to figure out how to remove the previously called orders from view.

Thanks!

[ajetrumpet]

I have a follow-up question to this: How could it be programed to clear itself? For instance, a user has searched the records for "person2" and now all the orders associated with person2 are displayed. I would like to put a button on a similar form that refreshes the form to have no records displayed and all combo boxes clear. I already have the combobox=null settled, I just need to figure out how to remove the previously called orders from view.

Thanks!

In my sample, for instance, all you would have to do is call the form_load() function:

Call Form_Load

behind the button.

The code is already written behind that event. Basically, it shuts the filter off and hides the subform. Technically, it does not clear the subform, as it can't be cleared because of its recordsource.

if you have more questions, start a new thread. This one is already closed. thanks!