saleemMSMS
Registered User.
- Local time
- Today, 12:51
- Joined
- Aug 12, 2009
- Messages
- 92
consider the following form and table set
also theres a query which contains the following fields
[Participant Group NAme] > all the names of the above tables
[Group Type] > VC for village committees, PG for producer groups, PH for Pharmacies
the group name combo box's Row source is this particular query.
what i need is whenever a user selects a group name from the interface, its corresponding Type should be automatically filled in the "group type" combo box
for example, if the user enters a name of a pharmacy, the group type should be automatically loaded as "PH"
what is the way of doing this ?
say i remove the "group type" combo box... still is there a way of saving the group type ?
please reply...
also theres a query which contains the following fields
[Participant Group NAme] > all the names of the above tables
[Group Type] > VC for village committees, PG for producer groups, PH for Pharmacies
the group name combo box's Row source is this particular query.
what i need is whenever a user selects a group name from the interface, its corresponding Type should be automatically filled in the "group type" combo box
for example, if the user enters a name of a pharmacy, the group type should be automatically loaded as "PH"
what is the way of doing this ?
say i remove the "group type" combo box... still is there a way of saving the group type ?
please reply...