Exit input box or value is ignored

[School Boy Error]

Hi, I have a form where the staff choose a date range and some other parameters. I noticed earlier the date range was being ignored and finally figured out that if I didn't click out of the End Date box before pressing OK the End Date was ignored and the default value was used. How do I get the OK button to make sure that the input box values are used. This is a screen shot of the form - https://snag.gy/JgA1YT.jpg Thank you!

[CJ_London]

Can I recommend you use the image button to display your images. For security reasons, many (myself included) are not prepared to click on links to external sites

With regards your problem, assuming OK is a button, it will get the focus when clicked so you will have moved the focus from the end date box. Implication being your code to create the WHERE clause is being created before the button is clicked

[School Boy Error]

Sorry, I've uploaded the image now. I thought it was triggered from the OK button press - this loads a report that populates from the query data using information on the form... Do you know how I could check the order or change it? As you can tell, I'm very new to all of this!

[CJ_London]

not sure what you have done, but there is only a blank image. Click on the insert image button (4th from the left) and follow the prompts

[CJ_London]

also, sounds like we need to see the code you are using - copy and paste this as text to your post and surround with the code tags (the # button) to preserve formatting

[School Boy Error]

This should hopefully work. The code called is just one line so the focus doesn't go to the button - how do I do this or set the focus away from any of the input boxes?

[isladogs]

Use Me.OK.SetFocus wherever necessary

[School Boy Error]

Use Me.OK.SetFocus wherever necessary

Brilliant, thank you. I'll give it a go.

[School Boy Error]

Worked perfectly! Thank you.

[isladogs]

You're welcome