Combobox control source differs from view

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

NeoFax - 12 Mar 2008 16:14 GMT

I have a form that allows the input of personell and their
supervisor. I use the same table for both the supervisor and employee
and just update the field supervisorID to match the primary key of the
table. However, on the form I want to show the Supervisors
BadgeNumber but write the primary key number to the SupervisorID.
This is not working. I have tried pretty much everything I can think
of to do this other than duplicating the table. Here is what the table
looks like:

nameID(PK) autoNumber
FirstName Text
LastName Text
BadgeNum Text
Department Text
WorkNum Text
SupervisorID Number (should equal nameID of supervisor)

Reply to this Message

Allen Browne - 12 Mar 2008 16:33 GMT

Set the combo's RowSource like this:
SELECT NameID, BadgeNum
FROM tblEmployee
ORDER BY BadgeNum;

Other properties:
Control Source: SupervisorID
Row Source Type: Table/Query
Bound Column: 1
Column Count: 2
Column Widths: 0

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have a form that allows the input of personell and their
> supervisor. I use the same table for both the supervisor and employee
[quoted text clipped - 12 lines]
> WorkNum Text
> SupervisorID Number (should equal nameID of supervisor)

Reply to this Message

NeoFax - 12 Mar 2008 19:29 GMT

On Mar 12, 11:33 am, "Allen Browne" <AllenBro...@SeeSig.Invalid>
wrote:

> Set the combo's RowSource like this:
> SELECT NameID, BadgeNum
[quoted text clipped - 31 lines]
>
> - Show quoted text -

Thanks!

Reply to this Message