A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Filter Table in Subform Control according to TextBox control value



 
 
Thread Tools Display Modes
  #1  
Old May 14th, 2010, 11:22 AM posted to microsoft.public.access.forms
K[_4_]
external usenet poster
 
Posts: 25
Default Filter Table in Subform Control according to TextBox control value

Hi all, I have put Subform control on a Form1 and in Source Object of
that Subform I selected Table1 from drop down list. I also got Text
box control on Form1. In the first column of the Table1 which
appearing in Subform I got Ticket No. What I need that when i type
that Ticket No in Text box control the Table1 in Subform should get
filter on that Ticket No row. Please can any friend can help
  #2  
Old May 14th, 2010, 12:24 PM posted to microsoft.public.access.forms
BruceM via AccessMonster.com
external usenet poster
 
Posts: 448
Default Filter Table in Subform Control according to TextBox control value

More information about the tables would help. I will use tblMain as the name
of the Record Source for Form1. Are tblMain and Table1 related? If so, on
what field? Typically you would set the Link Child and Link Master
properties of the subform control to the name of the linking field, so that
the subform shows only the records that are related to the main form's record.


K wrote:
Hi all, I have put Subform control on a Form1 and in Source Object of
that Subform I selected Table1 from drop down list. I also got Text
box control on Form1. In the first column of the Table1 which
appearing in Subform I got Ticket No. What I need that when i type
that Ticket No in Text box control the Table1 in Subform should get
filter on that Ticket No row. Please can any friend can help


--
Message posted via http://www.accessmonster.com

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:24 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.