insert frame value as query parameter

  • Thread starter Thread starter ragsman via AccessMonster.com
  • Start date Start date
R

ragsman via AccessMonster.com

Hi, I have this query in VB for an afterupdate event

strFilter = "([ch_request] Like '*" & [txtTracking] & "*') and ([frFixed] =
[fix complete])"
Me.Filter = strFilter

the idea is to change the query based on the values of a 2 state option group
[frFixed] which is either 0 or -1 compared to the field [fix complete] from
the table.

This query works, but it prompts me for the values of [frFixed] instead of
taking it from the option group value on the form. I know the value is there,
because I can output it with

MsgBox ([frFixed])

How can I make this query use the value of the option group [frFixed]
without manually entering it? there may be improper sql syntax here, too.

Thanks,

Mark
 
Dear Mark:

In order for a query to reference a control, it must be done in the format:

[Forms]![FormName]![ControlName]

In the above, substitute the actual name of the form and of the control.

Tom Ellison
 
That' s what I needed! works great!
Thank you!

Mark

Tom said:
Dear Mark:

In order for a query to reference a control, it must be done in the format:

[Forms]![FormName]![ControlName]

In the above, substitute the actual name of the form and of the control.

Tom Ellison
Hi, I have this query in VB for an afterupdate event
Click to expand...
[quoted text clipped - 22 lines]
Mark
Click to expand...
Click to expand...
 
Back
Top