Re: Data not refreshing on form

Tech-Archive recommends: Fix windows errors by optimizing your registry

Save and open in normal view - I really meant - you have finished changing
the form. Close and save it. Now open it in normal view.
Test to see if it works the way you want.

Jeanette Cunningham


"Joy" <Joy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4C027BBB-F1FB-4B3C-ABEF-793717CEDBF8@xxxxxxxxxxxxxxxx
The Navigation buttons are set to yes (its default)
I don't seem to have as an option "save and open in normal view" or "go to
a
new record" in the Format tab.. I checked the All tab too...

"Jeanette Cunningham" wrote:

You need to go to the next new record.
The easy way to do this is to set up the form to show the navigation
buttons.
Open the form in design view,
on the properties dialog,
on the Format tab,
set the property Navigation Buttons to Yes,
save and open in normal view, down the botton of the form will be a set
of
button,
to go to a new record, click the button with the star or asterisk on it.
That button will automatically save the current entered data and take you
to
the next new record.

Jeanette Cunningham

"Joy" <Joy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2340AA80-B7C5-428D-BAA9-F06F359DC0B7@xxxxxxxxxxxxxxxx
Hi Jeanette

I just realised that refreshing according to Help files functions to "
updates the data that already exists in your data*** or form". What I
really would like (not sure of terminology) is that when I hit the
refresh
button on the form, current data disappears, form is clean for a new
entry.
Could you pls help me..

Thanks Joy



"Jeanette Cunningham" wrote:

Joy,
to use unbound form to do this, you need to create an append query
that
will
add the data from the controls on the form to the whichever table or
tables
you want the data to go into.
Place a save button on the form.
Code the click event of the button to run the append query.

It is much more work to use unbound forms - you have to write code for
everything.
If you use bound forms, there is a lot of built in stuff that
automatically
saves records. That makes it quicker and easier to use.
Bound forms are one of the main benefits of using Access.

How did you go with creating that bound form we discussed yesterday -
are
there still some things that need fixing to make it work properly?

Jeanette Cunningham

"Joy" <Joy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F33779ED-D9C0-41AF-810B-3A906C7A35FD@xxxxxxxxxxxxxxxx
Hi, A beginner with Access who needs lots of help..
I've a form for users to enter, the fields are not bound to a table.
I would like to create a refresh button so that user can do another
addition. I've tried coding with
Me.Requery on the Refresh button but nothing happens. The current
data
stays.

I've also tried If Me.Dirty = True Then
Me.Dirty = False
End If

What else should I try?

Thanks Heaps, Joy












.

Quantcast