Form Logic

I'm having trouble figuring out exactly how to make something work with
regards to my forms. I have a database which I log and process warranty
claims. Part of our policy is that any parts claimed on warranty must be
held pending our request for those parts to be returned. I have my main
"claim" form with a subform that lists all the parts that the customer has
claimed. I have been using this database for 4 years now and it works great,
but I'm trying to implement another feature. I have added a check box to the
parts subform on my main form to indicate that I would like to request the
part back.

Ideally, what I need is to load a seperate form when I choose to do so
showing data from both the main form and the subform. This seperate form
would also contain some additional fields such as the vendor information, the
disposition of the part (i.e. scrapped, sent back to vendor, evaluated for
manufacturing defects), and other part specific fields. I would need to send
one request for the parts related to each claim. In other words, there would
not be a unique request for each individual part. Instead there will be a
request for a group of parts specific to each claim.

I'm sorry if I'm rambling, but I'm kinda lost as to what to do. Any help
would be much appreciated. Thanks in adavnce.

Shannan

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200911/1

"Maverick6197 via AccessMonster.com" u42957@uwe wrote in message
news:9ef5f07aaa025@uwe...
| I'm having trouble figuring out exactly how to make something work with
| regards to my forms. I have a database which I log and process
warranty
| claims. Part of our policy is that any parts claimed on warranty must
be
| held pending our request for those parts to be returned. I have my
main
| "claim" form with a subform that lists all the parts that the customer
has
| claimed. I have been using this database for 4 years now and it works
great,
| but I'm trying to implement another feature. I have added a check box
to the
| parts subform on my main form to indicate that I would like to request
the
| part back.
|
| Ideally, what I need is to load a seperate form when I choose to do so
| showing data from both the main form and the subform. This seperate
form
| would also contain some additional fields such as the vendor
information, the
| disposition of the part (i.e. scrapped, sent back to vendor, evaluated
for
| manufacturing defects), and other part specific fields. I would need
to send
| one request for the parts related to each claim. In other words, there
would
| not be a unique request for each individual part. Instead there will
be a
| request for a group of parts specific to each claim.
|
| I'm sorry if I'm rambling, but I'm kinda lost as to what to do. Any
help
| would be much appreciated. Thanks in adavnce.
|
| Shannan
|
| --
| Message posted via AccessMonster.com
| http://www.accessmonster.com/Uwe/For...forms/200911/1


If I understand you, you want to add a button your present form which
will
launch a new form/subform with different data about the same claim. From
that form you want to be able to print a report (request letter) based on
the state of your new check box.
--
Len
__________________________________________________ ____

remove nothing for valid email address.
|