Grant Allocation

  • Thread starter Thread starter Ammo
  • Start date Start date
A

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
 
Sorry, was meant to say in my original message; 'has the
following subform that consists of the following fields:'
 
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
.
Click to expand...
.
Click to expand...
 
Back
Top