By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,347 Members | 2,113 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,347 IT Pros & Developers. It's quick & easy.

MS ACCESS, Saving data from a pop up form

P: n/a
Hi, i have created a database to store contractors invoices. I have
approximately 9 tables and 3 forms. One of my forms(frmContractors)
has all the contractor details and this also contains a sub form which
includes cost details. In the sub form i have included a button which
activates a pop up form where additional details can be entered. I
would like the new data being entered in to the pop up form to be
saved so that it can be viewed in the sub form as the pop up form is
just a blank version of the sub form.

Sep 17 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Sep 17, 4:25 am, chuch <d_man...@hotmail.comwrote:
Hi, i have created a database to store contractors invoices. I have
approximately 9 tables and 3 forms. One of my forms(frmContractors)
has all the contractor details and this also contains a sub form which
includes cost details. In the sub form i have included a button which
activates a pop up form where additional details can be entered. I
would like the new data being entered in to the pop up form to be
saved so that it can be viewed in the sub form as the pop up form is
just a blank version of the sub form.
It sounds like you want to add record 2 while you are editing or
viewing record 1. Then you want record 2 to show instead of record 1
after record 2 has been added.
The best way to handle edits is to use the same screen for editing as
you would for adding. The calling routine determines which is being
done, and the editing/adding form is opened with the appropriate
parameter.
How are you doing the editing? How are you selecting which record to
edit? Are you using VBA? How are you programming the record append?

Sep 17 '07 #2

P: n/a

Well, My blank(pop up) form is to enter cost details which is a blank
version of my sub form. I would like to add as many records as
possible to the sub form, but when viewing the main form, you can
naviagte through the contract details and one contract can have many
different costs(subforms).

Sep 20 '07 #3

P: n/a
On Sep 20, 4:04 am, chuch <d_man...@hotmail.comwrote:
Well, My blank(pop up) form is to enter cost details which is a blank
version of my sub form. I would like to add as many records as
possible to the sub form, but when viewing the main form, you can
naviagte through the contract details and one contract can have many
different costs(subforms).
Is your subform on the main form a continuous form allowing you to see
multiple records with a scrollbar? Is there an Add or Save button on
the cost detail entry form? If the answer to the first question is
yes, and the answer to the second question in no, then I would setup
the code in the cost detail entry form to add the record manually with
a Save button. I would not connect the form to data, or use the
wizard. I would add what edit controls were needed and create
functions to read the data from the screen, write the data to the
table, and clear the screen. If the screen was also to be used for
editing existing cost detail, then I would add functions to read the
data from the table, and write the data to the screen. A previous
post (search on OldPro and WriteRecord) has examples of these
functions.

Sep 20 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.