Simple Requery Structure - Continous Forms

[JeffG3209]

I have been in the same rut for about two weeks now. I am losing patience with a requery. It should be easy as elementary, but it is beating me down.



My form name is SEARCH and it is a continuous form.
The field I would like to sort is [BUSINESS NAME]

I speculate that the VBA would consist of a
DoCmd.Requery.________

**This is for a text box entry. "Begins with" format

[June7]

I have never used DoCmd.Requery but the syntax would be:
DoCmd.Requery "control name here"

I have used:
Me.Requery
Form_formname.Requery
Me.controlname.Requery
Form_formname.controlname.Requery

See http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

[NTC]

requery or OrderBy? not clear from your post. Sounds like you want to change the form's OrderBy property and then refresh.

maybe helpful.

[June7]

Just reread original post. Is not clear if want to filter, sort, or goto record. Post complete procedure code if still need help.

[JeffG3209]

Just reread original post. Is not clear if want to filter, sort, or goto record. Post complete procedure code if still need help.

I would like to Filter a continuous form using a text box.

[June7]

So in code behind the main form, in some event such as a button Click or textbox AfterUpdate, refer to the subform container and its Form, like:

I know these three lines will work together.
Me.subformcontainername.Form.FilterOn = False
Me.subformcontainername.Form.Filter = "fieldname=" & Me.textboxname
Me.subformcontainername.Form.FilterOn = True

This might work, I haven't tried it yet.
Me.subformcontainername.Form.Filter = "fieldname=" & Me.textboxname
Me.subformcontainername.Form.Requery

[boblarson]

So in code behind the main form, in some event such as a button Click or textbox AfterUpdate, refer to the subform container and its Form, like:

I know these three lines will work together.
Me.subformcontainername.Form.FilterOn = False
Me.subformcontainername.Form.Filter = Me.textboxname
Me.subformcontainername.Form.FilterOn = True

This might work, I haven't tried it yet.
Me.subformcontainername.Form.Filter = Me.textboxname
Me.subformcontainername.Form.Requery

And make sure to change subformcontainername to the actual name of your subform control (the control on the parent form which houses the subform, but it isn't the subform itself)

(I just threw that in just in case because I've had people take even that as literal. )

[boblarson]

Oh, and if you use Me.TextBoxNameHere you still have to pass the filter with the field name as something like:

Me.subformcontainername.Form.Filter = "[Business Name Field] = " & Chr(34) & Me.textboxname & Chr(34)

or else it won't work.


(and you don't need the
Me.subformcontainername.Form.Requery
part)

[June7]

Thanks, Bob. Looks like I forgot to complete the criteria expression in my examples so did an edit of my post.