Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Code and a ComboBox
If you use the SendKeys command in your code, the caps lock and the num lock do not get affected. I used the code:<br><br>Private Sub PreviousField_AfterUpdate()<br> Forms![MyForm].[MyField].Requery<br> SendKeys...- Serpica
- Post #3
- Forum: Microsoft: Access Other topics
-
Design VBA Code to Default Previous Value
In my form I have seven fields I need to use this code for (Date, Job #, Class, Activity, Cost Type, Account, & Comment). I have entered the following code:<br><br>Private Sub Date_LostFocus()<br> If Nz(Date) = "" Then Me.Date = mdatVar1<br>End Sub<br><br>Private...- Serpica
- Post #6
- Forum: Microsoft: Access Other topics
-
Design VBA Code to Default Previous Value
Jimmythegreek<br><br>I have tried different codes but am unsure which code to use in the LostFocus Action. Could you please help figure out the code I would need say for the field "Date".- Serpica
- Post #4
- Forum: Microsoft: Access Other topics
-
Design VBA Code to Default Previous Value
--------------------------------------------------------------------------------<br>I need a code to represent that if I press "Enter" in a field on my form AND the field is left blank, Access will copy the value of the previous record for that field.<br>Example:<br><br>First Record -...- Serpica
- Thread
- Replies: 5
- Forum: Microsoft: Access Other topics
