help with form with source and destination fields

rsbutterfly16

Registered User.
Local time
Yesterday, 19:26
Joined
Jun 5, 2006
Messages
77
hi guys, I have two tables in my form one used as a source (contracts ) and
then the other one used for destination (Destination).

basically my two tables have the same columns:
contract id, contract type and contract name.

what i need to figure out is that in my data entry form i have a combo box( the source is coming from a query based from contracts table)
that list all my contract ids from contracts table. when a user selects a contract id to automatically filled my texbox with the correspondant contract type. It does not have to show in the form as long as it is populated in my destination table which has a column contract type.

can someone help please
 

Users who are viewing this thread

Back
Top Bottom