RE: Record Form

Hi again,

Thanks for the reply. Actually, you were clear enough before, but I just
didn't think you were because it doesn't make a lot of sense to me since, in
a table, I've not run into that situation before.

Sounds like maybe a filter is being applied to the form. You can open the
form in design mode and, on the data tab of the properties window, check the
filter property to make sure it's clear.

IF that's not it, how is your form opened? I think there's a filter
argument in the docmd object's openform method so maybe, if you open the form
by way of a control like a command button or a combo box, you need to check
the code behind that control.

Hope that helps,
CW



"Rhianne" wrote:

I will attempt to explain myself in a more articulate manner.

I have created my database based on tables, which are input through the form
I designed.

When I input the information into the form, then it only stays there for as
long as I have the form open - I can change which form and therefore which
"record" I am looking at. Once I have saved and closed, the information has
gone from the form view and is saved in table.

I have since altered this so that any new information I input into the table
through the form, will stay in a "record" in the form.

What I want to do is to be able to have all my exisiting records that are
available in table view, to be available in form view also, therefore making
my database more user friendly.

Does this now make sense?

"Cheese_whiz" wrote:

Hi Rhianne,



"Rhianne" wrote:

I have altered data entry to NO.

What I want to know if what is saved in my tables can no be shown in
records? I have altered it so that new entries can be still seen, but I want
to have existing info showing.


What is saved in your tables ARE records, so I'm confused about what you
mean.

What style of form are you using (single form, data***, continuous)? A
single form shows one record at a time. Data*** and continuous forms show
multiple records at a time.

If you want to check the form style, open the form in design view and click
on the format tab and check the 'default view'.

If that's not what you are looking for, then I'm confused and either you
will have to help me understand a little better what you are trying to
accomplish and what you have, or maybe someone else understands and will jump
in and help.

CW


"Cheese_whiz" wrote:

Hi Rhianne,

Just something a bit picky to start: records aren't 'saved' to form view.
Records are saved, if anywhere, to tables. Forms are used to add/edit
records, and display records. So, your problem is that your form isn't
displaying the records you want to see.

Usually this is a matter of turning the 'data entry' property of the form to
'no'. To do so:

1. Open your form in design view. When you open design view, the form
itself is selected by default.
2. Hit the f4 key to open the properties window.
3. Left click the 'Data' tab.
4. Change the 'Data Entry' property to 'no'.

You will also have to address how users will navigate to different records.
If they aren't already displayed at the bottom of your form, you can show the
built-in navigation controls by:

1. While still in design view with the form selected, click on the 'Format'
tab.
2. Verify/change the 'Navigation Buttons' property to yes.

You may not want to use the navigation buttons, and opt for a combo box
alternative to get to individual records. There are also user-made
alternatives to the built-in navigation buttons that can easily be found via
google.

Hope that helps,
CW

"Rhianne" wrote:

I have been inputting into my database and noticed that records were not
saving in form view, but only in the table. I have since altered my settings
so that the record will stay in form view - so as to make it more user
friendly.

However, I now wish to make the info in my table available in records on
form view. Is this possible?
.

Loading