Record Form

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

Guest

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?
 
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
 
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.
 
Hi Rhianne,



Rhianne said:
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.
Click to expand...


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, datasheet, continuous)? A
single form shows one record at a time. Datasheet 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
 
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?
 
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
 
I tried to do what you suggested - check the filter. But there are two
filters in data (in the db properties), apply and on. Which must be clear
etc...

Do you think this is why I cannot see my table data in form view?
 
Hi Rhianne,

Rhianne said:
I tried to do what you suggested - check the filter. But there are two
filters in data (in the db properties), apply and on. Which must be clear
etc...

Do you think this is why I cannot see my table data in form view?
Click to expand...

It's certainly one possibility. If you have a bound form and the form does
NOT have the 'data entry' property set to yes, then it should display all the
records in the table or query to which it is bound UNLESS there is something
else limiting the records displayed. One thing that does that (limits the
records displayed) is a filter. Another thing that can do that is a
parameter set in a query. If your form is bound to a query, then you can
open the query in design view and check the 'criteria row for any fields that
have criteria entries.

One other thing you might try just in the way of isolating the issue. You
might try making an autoform (columnar is fine) based on the same record
source (table or query) as your current form. Using autoform just saves
time, particularly when this is just for testing. Then save the form and and
reopen it and see what records you can navigate to through it using the
navigation buttons. Look down at the navigation buttons and see how many
records it says are in the recordset. Compare that with the number of
records your table says it has when viewed in datasheet view.

If you can get to all the records using this new form, then I'd say it's NOT
an issue with the record source and is either something in your form, or
maybe (as mentioned above) something like a filter being applied when the
form is opened.

If that's the case, and none of the other suggestions I made hits on the
problem, then you can either hope someone else chimes in with better info
(quite possible) and/or you might consider just taking the autoform you made
for testing and just using it (after moving the controls around to get the
appropriate layout) as the basis for a replacement form. That wouldn't
necessarily give you the 'answer' to the problem, but it would be a way
around it and after a certain amount of time investment, that may be good
enough for now...

Sorry I couldn't be of more help. I can't think of anything else if it's
not one of the things I've already addressed...

CW
 
CW imho you are doing a great job!! :-)

Cheese_whiz said:
Hi Rhianne,



It's certainly one possibility. If you have a bound form and the form does
NOT have the 'data entry' property set to yes, then it should display all the
records in the table or query to which it is bound UNLESS there is something
else limiting the records displayed. One thing that does that (limits the
records displayed) is a filter. Another thing that can do that is a
parameter set in a query. If your form is bound to a query, then you can
open the query in design view and check the 'criteria row for any fields that
have criteria entries.

One other thing you might try just in the way of isolating the issue. You
might try making an autoform (columnar is fine) based on the same record
source (table or query) as your current form. Using autoform just saves
time, particularly when this is just for testing. Then save the form and and
reopen it and see what records you can navigate to through it using the
navigation buttons. Look down at the navigation buttons and see how many
records it says are in the recordset. Compare that with the number of
records your table says it has when viewed in datasheet view.

If you can get to all the records using this new form, then I'd say it's NOT
an issue with the record source and is either something in your form, or
maybe (as mentioned above) something like a filter being applied when the
form is opened.

If that's the case, and none of the other suggestions I made hits on the
problem, then you can either hope someone else chimes in with better info
(quite possible) and/or you might consider just taking the autoform you made
for testing and just using it (after moving the controls around to get the
appropriate layout) as the basis for a replacement form. That wouldn't
necessarily give you the 'answer' to the problem, but it would be a way
around it and after a certain amount of time investment, that may be good
enough for now...

Sorry I couldn't be of more help. I can't think of anything else if it's
not one of the things I've already addressed...

CW
Click to expand...
 
Hi Rhianne,

For what it's worth I think CW has given you your solution here, when he (or
she?) talks about the style of form you are using - single, datasheet or
continuous. Having read all of the conversation I believe you will get the
view you want if you change the Form Format Default view to "Datasheet", in
the form properties as per CW's instructions.

If that's not it my next step will be to butt the hell out :-)

cheers,
Helen
 
You have been so helpful!

Unfortunately, I do not understand most of the jargon you used. SOrry! Have
printed off your last answer and trying to work my way through it.

But also at the same time I need to know how to print off queries - I've
added another question, if you wouldn't mind looking at that. Thanks!
 
I have found the filter and it is clear.

There is no problem with the information still showing in form view, with
the new records I am creating. They appear in the table and the form view.

I want to be able to display the table records that are already included,
but do not show in form view.

I feel that somehow it will not be possible! Grrrr!
 
Back
Top