Still no luck: pulling criteria from a form.

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

Guest

Sorry for the re-post but the proir thread ended and I'm still dead in the
water.

So again, if anybody can help, I'd be appreciative.

I am trying to pull a form field as criter for the underlying query. I
enter [Forms]![frm_DealMaster]![Staleflag] I get this using the builder and
browsing to the form so I know spelling and existence are not issues.

Everytime, I get "Enter Paramete Value". Why can it not locate this field?
 
Sorry for the re-post but the proir thread ended and I'm still dead in the
water.

So again, if anybody can help, I'd be appreciative.

I am trying to pull a form field as criter for the underlying query. I
enter [Forms]![frm_DealMaster]![Staleflag] I get this using the builder and
browsing to the form so I know spelling and existence are not issues.

Everytime, I get "Enter Paramete Value". Why can it not locate this field?
Click to expand...

Two questions:

- Is the Form open at the time you run the query?
- Could you post the actual SQL of the query? Specify the datatypes of
the fields.

John W. Vinson[MVP]
 
John,

Your questions prompted me to try running the query with the form open. I
didn't get the error this time but, it failed to pull the form field's value.
Would you still like to see th SQL? Or is there something simple I'm doing
wrong?

The form field I'm trying to pull is a check box. Does a check return "1"'s
and "0"'s?

John Vinson said:
Sorry for the re-post but the proir thread ended and I'm still dead in the
water.

So again, if anybody can help, I'd be appreciative.

I am trying to pull a form field as criter for the underlying query. I
enter [Forms]![frm_DealMaster]![Staleflag] I get this using the builder and
browsing to the form so I know spelling and existence are not issues.

Everytime, I get "Enter Paramete Value". Why can it not locate this field?
Click to expand...

Two questions:

- Is the Form open at the time you run the query?
- Could you post the actual SQL of the query? Specify the datatypes of
the fields.

John W. Vinson[MVP]
Click to expand...
 
John,

Your questions prompted me to try running the query with the form open. I
didn't get the error this time but, it failed to pull the form field's value.
Would you still like to see th SQL? Or is there something simple I'm doing
wrong?
Click to expand...

The form must be open or it will indeed prompt you. I obviously cannot
tell what you might be doing wrong, since I cannot tell what you're
doing!
The form field I'm trying to pull is a check box. Does a check return "1"'s
and "0"'s?
Click to expand...

Actually, -1 is TRUE/Yes/checked and 0 is FALSE/No/unchecked.

John W. Vinson[MVP]
 
Back
Top