2 Form Questions

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

Hi
I would like to make a form that has 3 or 4 columns on
it. I would like the first column to equal the last
recordset, the middle two columns will be values that I
enter in and I want the last column to become the new
recordset (the last column will equal the first column
plus the middle two columns). Is this possible and if it
is how would I go about performing this? The middle two
columns will be values in another table, I don't know if
these two should be related or not. Thank you in advance
for your time and your help.
Eric
 
You can achieve this will subforms on the main form. I
need more clarification on what you are trying to achieve
for me to make a strong suggestion. I am not quite
understanding what you are trying to achieve.

MW
 
Matt
Thanks again for the reply. Basically what I want to do
is keep a database of a contract and it's multiple
versions and also I want to create a database of
proposals. Each new version of a contract is a result of
one or more proposals that have been added to the
previous contract version. What I was thinking about
doing was having a form that shows the previous version
of the contract (previous recordset) and a few combo
boxes and some text boxes where I could select a proposal
(from the proposal table) from the combo box and have the
related information automatically show up in the text
boxes (it would be numerical infomation). The last
column of textboxes would add up the numerical info from
the proposal with the numerical info from the previous
record (previous contract). I wanted the last column to
end up as the new recordset in my contracts table, I'm
not sure if there is a cmd button that could put the new
info into the contract table or if the Afterupdate could
be used to automatically enter the last columns info and
make it into a new recordset. Thanks again for the help
 
Thank you very much Matt. What you said was correct. I
will try it out, thanks again for the reply.
Eric
 
Back
Top