copy a text value of a form into table

  • Thread starter Thread starter Azad, DH, BD
  • Start date Start date
A

Azad, DH, BD

I have a entry form where I have a combo box to select material code. After
selecting material code from combo, other two text boxes will show material
name and unit that are dlooked up from item table. Now I 'd like to save
these two text boxes with other entries to a nother table called Product
details.


Pls help me.

Thank u all genious bosses for your kind help in advance.
 
It's unnecessary and redundant to store those attributes in more than
one table. The only value you need to store is the PK value of the item
(or material). The other attributes can be retrieved whenever you need
them by using a query, DLookup, combo box, etc.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

save a dlooked up text box value of a form into table 1
Linking Tables for combo boxes 1
unbound text box on form equal to value of column in drop down lis 1
One column of a list box does not display for all users. 6
Why is combo box is changing values in table? 2
Auto filling fields in a sub-form (Access 2003) 1
Data entry to table from a form 1
Populate with the latest Data 4

Back
Top