Switchboard

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In an existing switchboard i added an additional button and linked a query
with parameter criteria . this same parameter criteria is used by other four
queries. When I add my new query with parameter query the SB form view is
blank. but design view is there. When I remove the parameter query from my
view formview of SB is available. I will appreciate your help very much.

Thank you,
Lalitha
 
Check the query results. Your query is probably not returning any records.

So you need to add a phony record that will return until there are records.
In your criteria you can add and OR to pull the phony record - maybe a
critera like 999999 in an added text field.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Query Won't Run 0
crosstab parameterized query 1
Combo Box executing query, issues 4
Multiple Parameter Crosstab query filter by form 1
Report from a Crosstab w/Parameters 1
Parameter Value in Crosstab Query 4
Access 2007 syntax error 1
Parameter Queries in Crosstab Query 2

Back
Top