advancing to new record

[buckwheat]

I'm known for thinking outside the box which causes the many challenges I face in dbs. So is there an easy solution to clear the cbo box when a new patient is selected or do I still with my idea of multiple buttons?

[Dal Jeanis]

That just means, when you get good, you will know EXACTLY where the box is.

Try this - In the afterupdate of cboPatient, add lines set the cboCPT.Default = NULL or nothing or 0, I've forgotten which. Same for cboDx.

If that doesn't work (if you get bad records every time) then move the code to BeforeUpdate.

[buckwheat]

will give it a try. thanks!

[June7]

Actually, the property is DefaultValue:

cboCPT.DefaultValue = NULL