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 » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Parameter Query not working on Switchboard



 
 
Thread Tools Display Modes
  #1  
Old May 10th, 2005, 05:00 AM
Nic
external usenet poster
 
Posts: n/a
Default Parameter Query not working on Switchboard

Hi!
Newbie here so please be patient with me...........
I have set up a form that is linked to a parameter query that displays
records only with a certain value that you enter into a data box on opening
of that form. This works with no problems on the form itself but I have
created a switchboard and the parameter data box does not open when I open
this form from the switchboard.

Firstly, can a form linked to a parameter query be run from a switchboard?
And secondly, why won't mine work??

Thanks in advance
Nic
  #2  
Old May 12th, 2005, 04:37 AM
Larry Daugherty
external usenet poster
 
Posts: n/a
Default

You're getting too tricky for yourself with no added value.

It is very unusual to have to answer a parameter query in order to
complete the opening of a form.

You can achieve the same result by placing a combobox in the header of
your form that runs exactly the same query - where the criteria line
now says forms!myform!MyCbo.

That form can be opened from a switchboard.

Some events arent triggered when the operation is via code rather than
keyboard.

HTH
--
-Larry-
--

"Nic" wrote in message
...
Hi!
Newbie here so please be patient with me...........
I have set up a form that is linked to a parameter query that

displays
records only with a certain value that you enter into a data box on

opening
of that form. This works with no problems on the form itself but I

have
created a switchboard and the parameter data box does not open when

I open
this form from the switchboard.

Firstly, can a form linked to a parameter query be run from a

switchboard?
And secondly, why won't mine work??

Thanks in advance
Nic



 




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
Parameter not Working; Returning all Values DEI General Discussion 1 March 25th, 2005 07:25 PM
Populate report header field from query parameter jh Setting Up & Running Reports 7 November 13th, 2004 06:38 AM
Convert to a Parameter Query Al Eaton General Discussion 3 July 9th, 2004 04:05 PM
Parameter Query Help mark Running & Setting Up Queries 4 June 2nd, 2004 04:40 PM
Using a query with a replaceable parameter as the source of a control Hoo Running & Setting Up Queries 1 May 30th, 2004 07:07 AM


All times are GMT +1. The time now is 09:27 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.