Grant Allocation

[Ammo]

Hi,

I have created form called frm_GrantApplicant that
consists of following fields:

GrantApplicant, AmountGrantAppliedFor,
ReasonForGrantApplication, GrantStatus

User input a value for the AmountGrantAppliedFor and
check/tick the GrantStatus field if grant application is
successful.

I then have another form called frm_GrantPot that consists
of the following fields:

GrantPotName, AvailableGrant, TotalGrantRemaining

and the following subforms:

DateGrantAllocated, GrantRecipient, ReasonGrantAllocated,
AmountGrantAllocated

The 'TotalGrantRemaining' field consists of the following
control source: =[AvailableGrant]-[frm_GrantAllocation
Subform].Form!TotalGrantAllocated

The 'GrantRecipient' field is set to combo box and
consists of the following row source property:

SELECT [tbl_GrantApplicants].[GrantApplicant],
[tbl_GrantApplicants].[GrantStatus] FROM
tbl_GrantApplicants WHERE ((([tbl_GrantApplicants].
[GrantStatus])=Yes));

On the frm_GrantPot form when I select a GrantRecipient
from the combo box I would like the
corresponding 'AmountGrantAppliedFor'
and 'ReasonForGrantApplication' values to appear that is
entered in the frm_GrantApplicant form for that record. I
would really be greatful if someone could help me on this.

Please also copy your replies to the email specified in
the 'Senders Email' field. Thank You.

Kind Regards

Ammo

 

[Ammo]

Sorry, was meant to say in my original message; 'has the
following subform that consists of the following fields:'

 

[Ammo]

Hi All,

I am going to explain the problem I wish to solve in a
different way:

I have table called tbl_GrantApplicants that consists of
the following fields:

GrantApplicantNumber (Primary Key), GrantApplicant,
AmountGrantAppliedFor, ReasonForGrant, GrantStatus (yes/no
data type, tick = yes, unticked = no), GrantConditions

I have another table called tbl_GrantAllocation that
consists of the following fields:

GrantAllocationNumber (Primary Key), DateGrantAllocated,
GrantRecipient (values in this field selected from
combobox using lookup function), ReasonForGrant,
AmountGrantAllocated

The row source for the lookup function for the
GrantRecipient field in tbl_GrantAllocation is as follows:

SELECT [tbl_GrantApplicants].[GrantApplicant],
[tbl_GrantApplicants].[GrantStatus], [tbl_GrantAllocation].
[AmountGrantAllocated] FROM tbl_GrantApplicants,
tbl_GrantAllocation WHERE ((([tbl_GrantApplicants].
[GrantStatus])=Yes));

Basically what I wish to achieve is when you select
a 'GrantRecipient' value from the combobox I want the
corresponding 'ReasonForGrant' and 'AmountGrantAllocated'
values to appear from 'tbl_GrantApplicants' table. Where
AmountGrantAllocated is the same as AmountGrantAppliedFor.
I hope this makes sense.

Kind Regards

Ammo

-----Original Message-----
Sorry, was meant to say in my original message; 'has the
following subform that consists of the following fields:'

-----Original Message-----
Hi,

I have created form called frm_GrantApplicant that
consists of following fields:

GrantApplicant, AmountGrantAppliedFor,
ReasonForGrantApplication, GrantStatus

User input a value for the AmountGrantAppliedFor and
check/tick the GrantStatus field if grant application is
successful.

I then have another form called frm_GrantPot that consists
of the following fields:

GrantPotName, AvailableGrant, TotalGrantRemaining

and the following subforms:

DateGrantAllocated, GrantRecipient, ReasonGrantAllocated,
AmountGrantAllocated

The 'TotalGrantRemaining' field consists of the following
control source: =[AvailableGrant]-[frm_GrantAllocation
Subform].Form!TotalGrantAllocated

The 'GrantRecipient' field is set to combo box and
consists of the following row source property:

SELECT [tbl_GrantApplicants].[GrantApplicant],
[tbl_GrantApplicants].[GrantStatus] FROM
tbl_GrantApplicants WHERE ((([tbl_GrantApplicants].
[GrantStatus])=Yes));

On the frm_GrantPot form when I select a GrantRecipient
from the combo box I would like the
corresponding 'AmountGrantAppliedFor'
and 'ReasonForGrantApplication' values to appear that is
entered in the frm_GrantApplicant form for that record. I
would really be greatful if someone could help me on this.

Please also copy your replies to the email specified in
the 'Senders Email' field. Thank You.

Kind Regards

Ammo
.

.