table to subform

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

Guest

I have a data entry form that saves the entered data into two tables
This part works great.
However, I would also like the form to save the entered data in the same format as the form

So is there a way to save a form's data into tables as well as the subform format
Right now, when I save, the Navigation Buttons do nothing because no new records are being saved

Or, is there a way to bring back the data in table form into a subform that looks exactly like the data entry form.
 
What are you trying to "save in the same format"? If you are using an input
mask with characters in it, the mask can be told to save the characters with
the data. If all you are wanting is formatting, then set the format
properties of the control in the display form. If you set the input mask
and/or formatting in the table design mode then use drag and drop to place
the fields on a form, this will carry over to the form automatically. If you
already have the form made, you'll need to go back into design mode for the
form and set these items on the form's controls yourself.

--
Wayne Morgan
Microsoft Access MVP


Roger said:
I have a data entry form that saves the entered data into two tables.
This part works great.
However, I would also like the form to save the entered data in the same format as the form.

So is there a way to save a form's data into tables as well as the subform format.
Right now, when I save, the Navigation Buttons do nothing because no new records are being saved.

Or, is there a way to bring back the data in table form into a subform
Click to expand...
that looks exactly like the data entry form.
 
The problem isn't with the format of the data that is saved. That's all good.
It's a little complicated to explain, but here goes.
I have a form (or a page) and I enter data into it.
When I click the save button, all the data entered into the form/page is put into a table.
The form/page then becomes blank and the cycle of entering and saving begins.
Here's the problem. The saving doesn't change the number of records, so I can't use the navigation buttons to go back through the forms/pages I've saved.
 
It sounds as if the Data Entry property of the form is set to True/Yes. This
will make the form allow new records only. Open the form in design view and
open the Properties sheet. The Data Entry setting is on the Data tab.
Another possibility is that this is an unbound form and all the work is
being done in code. If that's the case, you'll have a lot of modifying to
do.

--
Wayne Morgan
Microsoft Access MVP


Roger said:
The problem isn't with the format of the data that is saved. That's all good.
It's a little complicated to explain, but here goes.
I have a form (or a page) and I enter data into it.
When I click the save button, all the data entered into the form/page is put into a table.
The form/page then becomes blank and the cycle of entering and saving begins.
Here's the problem. The saving doesn't change the number of records, so I
Click to expand...
can't use the navigation buttons to go back through the forms/pages I've
saved.
 
Thanks Wayne! That didn't solve my problem but gave me a huge understanding of what my problem is.
I tried the Data Entry Property, and it still didn't work, probably because my form is all unbound and based on code.

So now that I know that I can't get the navigation buttons to work, I either have to change my codes so that it saves into table and form form. Is that possible? Or I have to find a way to convert the data in the tables back into form form. I can do the latter with a subform but when the form saves the page, it saves each entry as a separate record, so my subform displays only one record at a time.
 
one more question, does the Data Entry Property enable the New Record button in the navigation bar on the bottom too?
Thanks
 
If Data Entry is set to Yes, when you first open the form it will go to a
new record with none of the current records showing. Since you're at a new
record, the New Entry button is disabled. However, after entering your first
record, and moving to the next record (another new entry) the entry you just
made is still available for viewing and, if you allow, editing. If you go to
one of these previous new records, the new record button will be enabled as
a quick way to get to a new record, but when at the new record, it will once
again be disabled since you're already there.

--
Wayne Morgan
MS Access MVP


Roger said:
one more question, does the Data Entry Property enable the New Record
Click to expand...
button in the navigation bar on the bottom too?
 
You can disable the record selectors in the form's properties and keep track
of where you are in the recordset yourself and create your own buttons and
textbox to simulate the record selectors.

--
Wayne Morgan
MS Access MVP


Roger said:
Thanks Wayne! That didn't solve my problem but gave me a huge
Click to expand...
understanding of what my problem is.
I tried the Data Entry Property, and it still didn't work, probably
Click to expand...
because my form is all unbound and based on code.
So now that I know that I can't get the navigation buttons to work, I
Click to expand...
either have to change my codes so that it saves into table and form form.
Is that possible? Or I have to find a way to convert the data in the tables
back into form form. I can do the latter with a subform but when the form
saves the page, it saves each entry as a separate record, so my subform
displays only one record at a time.
 
Back
Top