repeat value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form in which I enter a S/O# multiple times in order to attach Item#
and qty. I may have to enter the S/O# 20 times. I know I can hit the cntl+'
key to repeat the value but I would like the value to auto repeat until I
change it to a new value.
 
On the After update event of the S/O# field you can write the code

Me.[S/O#].DefaultValue = """" & Me.[S/O#] & """"

To set the default of the field every time you change it
 

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

Access Macro Repeat Expression using value of a field in table 0
Outlook IMAP 0
Count the Repeated values 1
Unbound text box repeats for every row on a continuous form. 3
Scrabble Value calculation for Welsh words 0
Time input by work order 1
Data Entry to Form with repeat data. 13
Cannot reference object in custom collection 1

Back
Top