Field in form - Want entry to repeat itself

[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.

 

[Arvin Meyer MVP]

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?

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.

 

[Jeff Boyce]

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