Continuous search form won't open selected record in view form.

[orange]

Too many people start out think Access is the answer -- don't blame yourself for that. M$oft does a great marketing job (as do many DBMS suppliers) and have lot's of $$ incentive to do so.

One trick you can do is to put a debug.print in each procedure -- anything with code in it.
Form load, form open, button click etc.

Debug.print "entered procedure name here " 'you have to manually enter the procedure names

Then when you code runs, you can see the steps it went through. It may lead to a routine you didn't expect.
You can always use step debugging to help with problem resolution.



Good luck.

[IncidentalProgrammer]

I really do feel like Access can do what we need, it's just a matter of me getting to the point that I can get it to do it. I'd never heard of Access or done any kind of programming until last June, and the only training I have is books, internet, and trial & error.

I tried changing tactics, a little. Instead of pulling the result by PolID, I tried to write it to pull by policy number (PolNum, a text field), and effective date (PolEffDt, a date field). I've looked at numerous examples online, and my syntax looks right, but I keep getting a type mismatch error when I test it, and I'm not getting anything from debug.print on it. Do you see anything wrong with this statement?

DoCmd.OpenForm "frmPolicy3rd", , , "PolNum = '" & Me.ctlPolNum & "'" And "PolEffDt = #" & Me.ctlPolEffDt & "#"

[orange]

I don't see anything wrong with the code. But I don't see any reason to move away from PolId.
Something is interfering--I don't know what exactly. There must be some code executing that is changing
the logic.

[IncidentalProgrammer]

Well, I played around with the view form's settings. Apparently, there was an outdated query in the source field that I'd forgotten about. Now the button works!

Thank so much, Orange!

[orange]

Good stuff ---perseverance wins again!

[IncidentalProgrammer]

It was a good learning experience. I'm always searching for good syntax examples!