forms passing values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rpettis31 - 10 Apr 2008 14:59 GMT

I have a form that is filled out by Customer Service if there is a follow up
with the form an new form is generated and fields such as problem, item
number are passed to this new form.

My question is how do you get the values that are passed to the new form to
be saved. This way the new form can be opened for review.

Reply to this Message

Klatuu - 10 Apr 2008 15:42 GMT

Forms don't contain any data. they are just a "window" through which you may
manipulate data. So, you can't really save data in a form.

What is the record source for the first form?
What is the record source for the new form?
How are these data related?

Signature

Dave Hargis, Microsoft Access MVP

> I have a form that is filled out by Customer Service if there is a follow up
> with the form an new form is generated and fields such as problem, item
> number are passed to this new form.
>
> My question is how do you get the values that are passed to the new form to
> be saved. This way the new form can be opened for review.

Reply to this Message

Rpettis31 - 10 Apr 2008 17:04 GMT

The first form is called Customer service Issue it is linked to a table of
the same name. I have a date of issue field on the form whose control source
=date(). How do I caputure that date rather than everyday it changes due to
the command.

Also when I open the second form I am using =Forms!CustSvcIssue!Cust Issue Id.
This is to pull field values from the first form into the second form. What
I realize is that I can not open the second form on its own because the
information is not captured. I would like to be able to capture the data
((copy paste special values))
into the second form so it can be used on its own.

> Forms don't contain any data. they are just a "window" through which you may
> manipulate data. So, you can't really save data in a form.
[quoted text clipped - 9 lines]
> > My question is how do you get the values that are passed to the new form to
> > be saved. This way the new form can be opened for review.

Reply to this Message

Klatuu - 10 Apr 2008 17:10 GMT

You need a field in your table to store the date of issue.
Instead of putting = Date() in the Control Source, put it in the Default
Value property. Then bind the control the field to store the date of issue.

Now, for new records, it will default to the current date, but an existing
record will retain the original date. Then if you are opening the second
form based on a specific date, you wont have a problem.

Signature

Dave Hargis, Microsoft Access MVP

> The first form is called Customer service Issue it is linked to a table of
> the same name. I have a date of issue field on the form whose control source
[quoted text clipped - 21 lines]
> > > My question is how do you get the values that are passed to the new form to
> > > be saved. This way the new form can be opened for review.

Reply to this Message