Field in form - Want entry to repeat itself

  • Thread starter Thread starter Lynniebird
  • Start date Start date
L

Lynniebird

I am a beginner and I am looking to have the entry in a field repeat itself
on a form until a new entry number is entered. Is there an explanation of
how to do this?

Thanks.
 
Lynniebird said:
I am a beginner and I am looking to have the entry in a field repeat itself
on a form until a new entry number is entered. Is there an explanation of
how to do this?
Click to expand...

In the AfterUpdate event of the control that you enter data into use the
following code:

Me!ControlName.DefaultValue = """" & Me!ControlName.Value & """"

That's 4 double quotes on either side. Of course, you substitute your
ControlName for the one above.
 
Form(s) follow ... tables.

How your data is structured impacts how you use a form to update the table
data.

You've picked "having the entry in a field repeat itself" as a solution to a
business need/problem/issue.

If you'll provide a bit more description about that underlying business need
for which you're looking for a solution, and a bit more about the underlying
data/structure (examples help), folks here may be able to offer alternate
approaches.

Good luck

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top