Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
[b][red]This message was edited by Bill H at 2004-9-19 14:16:20[/red][/b][hr]
[b][red]This message was edited by Bill H at 2004-9-19 14:1:8[/red][/b][hr]
I am using Access 2000 and VB.Net. I have several tables, each of which I show on a datagrid in a different form, and that form only. What I want to do is a "search" and "sort" on each one of the tables when that form is on the screen by way of user input. I have created a "search" form with a textbox which I open on top of the current form. What I need to know is the code, (and where to put it), to take the input of the textbox on the search form and put the results in the datagrid on the bottom form. In other words.....I want this to work the same as the "find" function in an MS Works database where the "find" function brings up a window with a textbox for user input and then resets the datagrid to show only that information requested, and closes the "find" window. I also want to be able to do the same thing with a "sort" window. This doesn't seem like too big a task when the code and all are on the same form but I can't find any information on doing this from one form to another. Any help would be greatly appreciated. I can adapt the code from the first table to all the rest.
Thanx in advance !!!!!
Thanx a million for your help. I must be doing something wrong however as I added a textbox to my datagrid data form to try this and even though there doesn't seem to be anything wrong with the code, it does not update the text in the main form. I have the friends set up in a module and put the textbox code under an OK button on my search form. I don't know the term "Modally", I am bringing up my search form with:
dim objfrmsearch as new frmsearch
I also tried it both ways you had indicated. Perhaps I have the code for something in the wrong location. By the way, I used the wizard to set up my connection and datagrid which work fine.