command button

E

Erik

I have a form that i have created a command button to run through every text
box and copy the previous record information to the new record. I have use
the sendkeys command for the code example {tab}, true next line "^(')", true.
I have done this for each text box and it works fine. I am running into a
problem with the check box, the sendkeys option does not work on the form,
but will work on the table. Any help would be great thanks Erik
 
J

Jeff Boyce

Eric

Another approach would be to have each control "save" its value in that
control's Default Value in an AfterUpdate event for the control. That way,
the next record that gets created has the previous record's value as a
default for each control.

Just one person's opinion...

Jeff Boyce
<Access MVP>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA word change keys 0
Split form 0
Crating User Form to Add Names 1
Prompt For Replace in Selection And More... 0
How do I set focus (and select text) on a text box on a modeless userform? 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Select Text to End of Footnote 9
Setting Focus and Using SendKey 3

Top