Filter Subform
in [Forms]
|
From: K on 16 May 2010 04:54 Hi all, I have table in subform control which i have put on a Form call "Main Form". Table name is "Data" and Subform name is "Data Subform". On the Form "Main Form" just above from subform control i have also put unbound Textbox control which i call "txtSrch". I just want some kind of code or way that when ever i put a ID number in Textbox control which also appear in first coloumn of the Table which is in Subform then Subform should get filterd on that ID Number. I also want that if i put some kind of ID Number which dont appear to be in the Table of Subform then i should get message box say that "This ID dont exist". Please can any friend can help me on this.
From: mie via AccessMonster.com on 16 May 2010 05:01 You can start from here.. http://allenbrowne.com/ser-28.html K wrote: >Hi all, I have table in subform control which i have put on a Form >call "Main Form". Table name is "Data" and Subform name is "Data >Subform". On the Form "Main Form" just above from subform control i >have also put unbound Textbox control which i call "txtSrch". I just >want some kind of code or way that when ever i put a ID number in >Textbox control which also appear in first coloumn of the Table which >is in Subform then Subform should get filterd on that ID Number. I >also want that if i put some kind of ID Number which dont appear to be >in the Table of Subform then i should get message box say that "This >ID dont exist". Please can any friend can help me on this. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201005/1
|
Pages: 1 Prev: Alternate row color for combo box Next: updating table from recrodset |