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  

Combo box to search on a field in the subform



 
 
Thread Tools Display Modes
  #1  
Old April 9th, 2010, 05:47 PM posted to microsoft.public.access.forms
JLO
external usenet poster
 
Posts: 57
Default Combo box to search on a field in the subform

Is it possible to have a combo box search for a field that is the located on
the subform? I already have a combo box search for a field that is on the
main form however the customer would like to have a search option for a field
that is located on the subform. This is making me crazy so I thought I would
ask if it's possible. Thanks.
  #2  
Old April 9th, 2010, 08:32 PM posted to microsoft.public.access.forms
Al Campagna[_2_]
external usenet poster
 
Posts: 1,462
Default Combo box to search on a field in the subform

jlo,
Make that task a lot easier by placing a search combo in the Header of
the subform.
Then, you can use the same procedure you used on the main to do the same
type of search in the subform.
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

"jlo" wrote in message
...
Is it possible to have a combo box search for a field that is the located
on
the subform? I already have a combo box search for a field that is on the
main form however the customer would like to have a search option for a
field
that is located on the subform. This is making me crazy so I thought I
would
ask if it's possible. Thanks.



 




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 09:06 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.