COMBO BOX DATA DOES NOT APPEAR IN TABLE

  • Thread starter Thread starter niaz
  • Start date Start date
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.
 
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.
Click to expand...

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)?
 
Back
Top