mainform and pop-upform

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

Guest

I have a main form which people enter details in to which is then transfered
to a table.
there is a button on the main form which brings up another form that has 5
additional supplier entry details ie name address etc.
Once the pop-up form has been complete an enter button is pressed which
should close down the pop-up form and go back to the main form for completion.

I do not know what coding to use to store the pop-up form details until the
main form is completed and when we finish with the mainform that all details
from the main form and the pop-up form are stored onto the main table.

I hope someone can help me.
Thanks in advance
 
Is it my understanding that the pop-up form is calling up information from
an existant table? If this is the case, then taking the data from that
location and storing the information in another location is a bad idea. You
would be creating redunduncy information that is not necessary. If all you
need to do is get a suppliers information, you would be better off using a
combo box on your main form that gives the user a choice to pick the
supplier name. You do not need to display any address info as this is
usually displayed on a report. This is what relational databases are all
about.
 
Hi G. Vaught
The pop-up form is being used to add information, then same is the main form
and both forms details need to be added to 1 table.

The main form has all the questions which need to be answeredd but it also
provides the ability to enter 1 suppliers detials however if there are
multiple suppliers then a button is pressed on the main from which brings up
the popup form.

I need to know how to enter the details which are keyed in on the pop-up
form in to the table but only once the main form has been completed.

reason for this is depending on the suppliers location depends on which
record the details of supplier are to go against.

I hope the above makes sense.

Thanks again
 
Back
Top