automatically loading values to a field.

[saleemMSMS]

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...

 

[Zaeed]

Can you fix the post up please?

 

[saleemMSMS]

fix what bro ?

 

[Zaeed]

I can't see anything between the lines
"consider the following form and table set "
and
"also theres a query which contains the following fields"

 

[saleemMSMS]

hey thats funny...
hmmm what can i do... lets see.. i can see the images clearly though...
the images below "consider the following form and table set " are
http://i47.tinypic.com/ng7i3d.gif
and
http://i47.tinypic.com/18n8lf.jpg

and theres no image after "also theres a query which contains the following fields".. but text saying
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 ?

 

[Zaeed]

Lol ok, it seems it was my crappy browser at work that was at fault (IE6)

Do you have the group types stored somewhere?

 

[saleemMSMS]

oh yes..
i've forgot to mention about the table which refers to the form. it stores the group types.
it goes like this

[program attendance table]
ProgramID
GroupName
GroupType
TotalAttended