Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Auto-fill a TextBox from related table

Status
Not open for further replies.
MarkoKobal

MarkoKobal

IS-IT--Management
Jul 18, 2001
14
SI
I have simple case: two tables, ARTICLE and TYPE. (each article is one of the type).
ARTICLE(ID_Article, A_Name, ID_Type)
TYPE(ID_TYPE, T_Name)
This two tables are related through ID_Type.
Now I have a form for table ARTICLE, and I would like to add to this form a TextBox, in wich I would have only DISPLAYED the Type for the ARTICLE at the moment I fill in the ID_TYPE.

How would I do this?
 
Status
Not open for further replies.

Similar threads

PrimoSteve
  • Locked
  • Question
Fill in 2nd Textbox2 from Textbox1
Replies
3
Views
234
PrimoSteve
PrimoSteve
PrimoSteve
  • Locked
  • Question
Grid From 1
2
Replies
21
Views
1K
PrimoSteve
PrimoSteve
TomSalvato
  • Locked
  • Question
Getting the Monday date from a week number 1
Replies
2
Views
280
TomSalvato
TomSalvato
TrekBiker
  • Locked
  • Question
Running query with parameter from Inputbox 2
Replies
8
Views
282
TrekBiker
TrekBiker
Bubba002
  • Locked
  • Question
Pass a subform fieldname-ID as a string variable in CF expression
2 3
Replies
50
Views
914
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top