Thread: Filter Subform
View Single Post
  #2  
Old May 16th, 2010, 10:50 AM posted to microsoft.public.access.forms
mie via AccessMonster.com
external usenet poster
 
Posts: 9
Default 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