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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |