If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Form Logic
"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. | |
Thread Tools | |
Display Modes | |
|
|