Help With Access Problem

[twuncher]

Ok ive been stuck for ages fiddling about and i just needed some help so i thought i'd come to the experts

Ok heres what i want to do

Ive got a form with a combo box so you can select a record..

ive got an end date for this record that will be input aswell.

Ive got a table with the records and the retention periods(in days)..

and i want it so that when i select a record and input an end date that this will add the retention period onto the end date to give me a destruction date.
I want this destruction date to be saved into a table aswell

thankyou for your time

 

[SydneyGeek]

So, you've got something like --
[ItemID] [End Date] [Retention Period] [Destruction Date]?

First thing, [Destruction Date] is the result of a calculation. Therefore it should not be stored but should be in a query.
I would do the following:
Build a main form (unbound) with an unbound ComboBox that let me search for items using [ItemID] but show [Item Description].
On a subform with [ItemID] synchronised to the ComboBox (I can clarify if you need it), you have records based on a query with the 4 fields above and the [Item Description]. Now, when you select the item in the combo the corresponding record appears in the subform.
The [ItemID], [Item Description], [Retention Period] and [End Date] fields are from the table. You can enter the [Retention Period] if needed, and the [End Date]. For [Destruction Date] the RecordSource is
=DateAdd("m",[End Date],[Retention Period]) -- assuming that the period is months. If you want days or weeks, change the "m" to "d" or "w". Check the DateAdd function for correct syntax -- I may have the [End Date] and [Retention Period] the wrong way round.

Hope this gets you on the right track.

 

[twuncher]

thx il have a fiddle about with that

see what happens

again very much appreciated

 

[twuncher]

thx i got it working

your a star! ray: Im not worthy