Private Sub Command66_Click()
Dim stDocName As String
Dim stLinkCriteria As String
DoCmd.OpenForm "LoanNumber"
Forms("LoanNumber")("TextSearch").SetFocus
DoCmd.Close acForm, "LoanInfo", acSaveNo
'stLinkCriteria
Exit Sub
No, that doesn't work, that is what I currently have.
the code does work by means of setting focus to the textbox, but when I open the form it does not set focus to the textbox until I click on the form. Its as if the form is not ACTIVE or something, I have to activate the form somehow for the...
I have a button on Form1, when I click the botton I want to close Form1. Next, I want Form2 to open, Form2 consists of 1 textbox. Here is the key: I want the curser blinking on the textbox. Yes, I have tried OnFocus, and it works fine but only after I make the form ACTIVE (The the textbox has...
Yes, The problem is the sql statement, yes I know, but what I don't know is how to get the session variable = the recordsetID(departmentID)
The session variable = "a number"
the department ID = "a number"
I know my syntax is wrong with the quotes and parenthesis, my problem...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.