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  

four parameters in form for query in subform, subform does not change? Help?



 
 
Thread Tools Display Modes
  #1  
Old April 16th, 2005, 10:59 AM
Matthew Pilkington via AccessMonster.com
external usenet poster
 
Posts: n/a
Default four parameters in form for query in subform, subform does not change? Help?

Sorry I know I have posted this thread in General 2 but that was a mistake
and I need help pretty urgently

Problem? I have a query that runs on FOUR parameters in a form:
2 combo boxes and 2 text boxes,
but when the parameters are selected the subform does not change
The query runs fine though just the subform does not refresh
it does change however when i set the parameters then go into design view
and back to form view

any help would be greatly appreciated

Thanks

Mat

--
Message posted via http://www.accessmonster.com
  #2  
Old April 16th, 2005, 10:38 PM
Ofer
external usenet poster
 
Posts: n/a
Default

after updating the filter fields did you put me.subformname.requery?

"Matthew Pilkington via AccessMonster.com" wrote:

Sorry I know I have posted this thread in General 2 but that was a mistake
and I need help pretty urgently

Problem? I have a query that runs on FOUR parameters in a form:
2 combo boxes and 2 text boxes,
but when the parameters are selected the subform does not change
The query runs fine though just the subform does not refresh
it does change however when i set the parameters then go into design view
and back to form view

any help would be greatly appreciated

Thanks

Mat

--
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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Is it possible to show both "Yes" and "No" answers from a "yes/no" checkbox? Colin Foster New Users 28 March 18th, 2005 02:19 PM
subform's field and corresponding recordset out of sync? AB General Discussion 3 November 8th, 2004 10:54 PM
dlookup miaplacidus Using Forms 9 August 5th, 2004 09:16 PM
auto entry into second table after update Tony New Users 13 July 9th, 2004 10:42 PM
Recordset in subform based on field in parent form Lyn General Discussion 15 June 14th, 2004 03:10 PM


All times are GMT +1. The time now is 07:39 AM.


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