If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
Filter Subform
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. |
#2
|
|||
|
|||
Filter Subform
You already post this in Forms Programming.
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/For...forms/201005/1 |
Thread Tools | |
Display Modes | |
|
|