COMBO BOX DATA DOES NOT APPEAR IN TABLE

N

niaz

hi,
i have a form and a combo box which i selected value from employee table,
i select the id, empname appears, but in the master table employee name is
blank. how do i bring the value from emp table to master table (not form).
Pls help as my table looks incomplete, but this appears in form.
 
J

John W. Vinson

hi,
i have a form and a combo box which i selected value from employee table,
i select the id, empname appears, but in the master table employee name is
blank. how do i bring the value from emp table to master table (not form).
Pls help as my table looks incomplete, but this appears in form.

The employee name should exist only in the Employee table. In any other table
(your "master table" I presume) you should have only the numeric ID.

If you're using the table datasheet to interact with your database... don't.
That's not its function. You store data in the table appropriate for that data
- employee names and contact info in the Employee table, sale date and
customer ID in the Sales table, etc.

What is the Control Source of this combo box (the field in which the selected
value will be stored)? What is its Rowsource (post the SQL view if it's a
query)? What's the Bound Column (which field will get stored)?
 

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

Top