Filter OnLoad not working

[Brilstern]

Filter OnLoad

So I know this has been explained 1000 times but for some reason I am having trouble making it work. Does this look correct? Did I miss something, I will elaborate more if I at least have got this right. As of right now my form opens to a new record every time.

strFilter = "[ID] =' & Me.cbxRegion & '"
 
DoCmd.Close acForm, "frmRegion"
DoCmd.Close
DoCmd.OpenForm "frmRegionEdit", , , strFilter

I have ran my string through a message box/debug and it is returning the correct value. I am only using one column, and the first column is bound.

[Brilstern]

Not sure why this works. But I made it work by changing the filter.

strFilter = "[ID] =" & Me.cbxRegion

[Seth Schrock]

You need to add double quotes to break up your string. Right now it is all one big string.

strFilter = "[ID] ='" & Me.cbxRegion & "'"

***Edit***
Did see your second post. So cbxRegion must be a number and not text.

[Brilstern]

Seth,

I tried that with no success. Using my above mentioned method it worked.

[NeoPa]

Stevan.

Take your first line in the OP and, bearing in mind that the VBA side of things is using double-quote characters (") and the SQL is using single-quotes ('), go step-by-step and see what you expect to be passed from one to the other.

Remember, everything between the quotes (both types) is treated as string data which is not to be evaluated.

Separately, work out what you think each string should be. Now see where they differ. You'll see why by looking for where.

Once you have that understanding you should have the whole concept beaten and be able to handle all such situations in future with ease and a full understanding.