Recent content by mhowell

Thanks everyone. The spin button is the trick.

I tried your code and used the comma suggestion (after acFrom - DoCmd.Close acform , "frm_objects") and it worked.

Hi all, I am tyring to find an elegant way to increase or decrease a Quantity field (text box) by having the user use some sort of up and down arrows. Is ther anyway to determine if the user cliscked on an up scrool bar as opposed to a down scroll bar in a text box?

I believe that the return from the MsgBox is an integer (the value of vbYes). Response should be an integer and your if statement should be "If Response = 6 Then"

I want to use the RecordSelector to create a new record for a particular customer (create a new site record for a customer (Cusotmer - One to Site - Many). How can I access some event that will allow me to test if the RecordSelctor is at the EOF of the current Form Filtered record set...