custom dialog box

  • Thread starter Thread starter Ian S
  • Start date Start date
I

Ian S

I'm still getting the default prompt from a parameter
query before my custom dialog box appears.

On checking this with different criteria, it seems that
the default prompt input is used first. Then, if I hit
Shift-F9 to re-query, the second input is used. So, the
custom box IS working, but I can't suppress the default
prompt box.

The default prompt caption shows as Forms!CheckDate!Start
Date', when it SHOULD be going straight to [Forms]!
[CheckDate]![Start Date].

This should be so straight forward! What am I missing?
 
Ian S said:
I'm still getting the default prompt from a parameter
query before my custom dialog box appears.

On checking this with different criteria, it seems that
the default prompt input is used first. Then, if I hit
Shift-F9 to re-query, the second input is used. So, the
custom box IS working, but I can't suppress the default
prompt box.

The default prompt caption shows as Forms!CheckDate!Start
Date', when it SHOULD be going straight to [Forms]!
[CheckDate]![Start Date].

This should be so straight forward! What am I missing?
Click to expand...

If the control name has a space in it as you show above then it needs brackets around
it.

[Start Date]
 
Yep, its got the brackets.
Sounds like it should be working, eh?
Seems as if the query is treating the brackets as those
which 'set' the criteria, even though its supposed to be
pointing to a control on a form.

I've done this according to MS instructions, too.
I'm baffled. I really need this to work!
Any other ideas???

Regards,
Ian
-----Original Message-----
Ian S said:
I'm still getting the default prompt from a parameter
query before my custom dialog box appears.

On checking this with different criteria, it seems that
the default prompt input is used first. Then, if I hit
Shift-F9 to re-query, the second input is used. So, the
custom box IS working, but I can't suppress the default
prompt box.

The default prompt caption shows as Forms!CheckDate! Start
Date', when it SHOULD be going straight to [Forms]!
[CheckDate]![Start Date].

This should be so straight forward! What am I missing?
Click to expand...

If the control name has a space in it as you show above then it needs brackets around
it.

[Start Date]


.
Click to expand...
 
Ian S said:
Yep, its got the brackets.
Sounds like it should be working, eh?
Seems as if the query is treating the brackets as those
which 'set' the criteria, even though its supposed to be
pointing to a control on a form.

I've done this according to MS instructions, too.
I'm baffled. I really need this to work!
Any other ideas???
Click to expand...

Was it just typo then that your last message didn't include the brackets? Generally
when you make a form reference like that and it pops up a parameter window it either
means the form is not open or something is spelled wrong.
 
No, what I meant was that when the default prompt pops up
it contains that message, without the brackets. Sorry, its
a bit hard to describe... :)
In the actual query the brackets are there. Anyway, the
custom form DOES actually work, its just that the default
prompt pops up first!
So the reference and the spelling are obviously ok, I just
can't stop the default prompt. I've been on the MS site
and boards everywhere all day trying to get an answer to
this. Either there's something obvious here or its a mad
bug...
There have been similar problems I've seen but none of the
answers work - like adding SetWarnings to the Macro for
example...

thanks for your replies - if you have any ideas I'm all
ears!
regards,
Ian
-----Original Message-----


Was it just typo then that your last message didn't
Click to expand...
include the brackets? Generally
 
Back
Top