I have written this cdoe for my database,
Private Sub Text333_KeyPress(KeyAscii As Integer)
If KeyAscii = 48 Then
DoCmd.Close acForm, "Medication Problems", acSaveYes
DoCmd.OpenForm "Medication Problems (Short Form)"
ElseIf KeyAscii = 49 Then
Text335.SetFocus...
I have written this cdoe for my database,
Private Sub Text333_KeyPress(KeyAscii As Integer)
If KeyAscii = 48 Then
DoCmd.Close acForm, "Medication Problems", acSaveYes
DoCmd.OpenForm "Medication Problems (Short Form)"
ElseIf KeyAscii = 49 Then
Text335.SetFocus...
Can anyone give me advice on how to link controls in a form. I want to give the user the ability to click a check box. By clicking the check box, information from say control 1 on form 1, will automatically be put in control 2 on form 2, in essence I want to link controls on two seperate forms...
I am having trouble writing code so that I may be able to give the user of my database directions when they click on a control. The idea is that users will click an option button in a option group, afterwards a prompt will appear telling them that Phase I is complete. Help is greatly appreciated.
I basically want a user to be able to write an answer to a question in a text box, after they write the text in the text box, I would like the focus to switch to another control when the user hits enter.
My problem is that I have an option group with two option boxes, one says yes and the value is 1, and the other option box says no and the value is 2. What I want to do is that when a user clicks the option button yes, I want the focus to move to text box 98, otherwise, when the user clicks the...
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.