Inconsistant Textbox Control Source

T

Tru

I have a textbox (txtEmployeeID) whose Control Source is = to a combo box
(cboEmployee) first column which is hidden, ei., =cboEmployee.Column(0)

The problem is when I navigate record to record txtEmployeeID is sometimes
blank (null). Why does this happen when txtEmployeeID Control Source is
=cboEmployee.Column(0). It works fine when I use this instead =cboEmployee
in the Control Source but that is not the value I want the txtEmployeeID to
display.

I have tried using the Forms OnCurrent Procedure but this happens there also.
 

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

DLookup in Continuous form 0
Trouble with the following 4
Problem with Items Selected from List Box 2
TextBox Object Control Source Expresion, trouble with 3
Data in Textbox not storing on Table 6
Can I limit record update? 4
Basing a subform on a selection from either of two subforms 3
=CStr([Recordset].[AbsolutePosition]+1) works, and doesn't work 3

Top