I have posted a copy of my SS athttp://www.telfordsteamrailway.co.uk...cker_weekh.xls
On the summary page click on 'Enter Sale' and notice that Customer Advisor' text box gets the focus and the cursor is flashing. (Which is what I want).
Enter any name and a sale value (say 'A' and '1') and click the 'OK' button
But when I tried to enter another sale the OK button still had the focus.
So in the VBA Project / Forms / frm_sale / OK Click event - near the bottom
I added a set focus before the 'frm_sale.hide' - This removed the focus from the 'OK' box - but the cursor is still not in the text box, and it needs to be clicked in order to enter text.
This is clearly something trivial I am missing - but the blinkers are on and I cant spot it
Last edited by Dave Hawley; October 16th, 2006 at 20:17.
Move the ca_name.Setfocus from the end of the Ok_Button event to the Userform Activate event
VB:'clear form Call clear_button_Click 'aaaarggggh '' ca_name.SetFocus frm_sale.HideVB:Private Sub UserForm_Activate() ca_name.SetFocus End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)