rsbutterfly16
Registered User.
- Local time
- Today, 03:58
- 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
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