AutoUpdate/Combo box won't select

[Charles G via AccessMonster.com]

I have tblCPFTellers with these fields:
[TellerFirst] [TellerLast] [BNumber] [CPF] [CPF ID] [WorkStatus]
The primary key is [BNumber] and all corresponding fields relate directly to
the BNumber.

Question 1:
I want to create a Form bound to another table with a combo box list of
BNumbers. The teller can go in, select their BNumber, and their FirstName,
LastName, and CurrencyProcessingFacility fields will auto populate. Then they
can proceed to key in other fields.

Question 2:
In my Form I have a combo box [CurrencyProcessingFacility] bound to
tblCPFTellers and the field [CPF].
Row Source:Select DISTINCT [CPF] FROM [tblCPFTellers];

A list of CPF's come up in the combo box, however, when I try to select one
it will not populate the combo box. Form Properties:

Allow Edits: Yes
Data Entry: Yes

Thanks,

-Charles-

 

[Steve Schapel]

Charles,

You say that the form is bound to "another table". The only field
included in this other table that corresponds with a field in the
tblCPFTellers table should be BNumber. There should not be a
CurrencyProcessingFacility field in the table that the form is bound to.
Once the BNumber is entered into the "another table", the related
fields (TellerFirst, TellerLast, CPF) from the tblCPFTellers table will
be known. There are a number of possible approaches to having the
values of these related fields shown on the form, and these approaches
are explained in this article...
http://accesstips.datamanagementsolutions.biz/lookup.htm

 

[Charles G via AccessMonster.com]

You are correct in that my other table only includes the BNumber as a simlar
field. Both tables share the BNumber field and that's it. However, I found
out today that not all the tellers have an assigned BNumber, so, I can't use
that to update the name and CPF fields.
I still can 't figure out why a list of CPF's come up in the combo box, but
it will not populate the combo box.

I currently have it rigged up with this in my RowSource:
"Norfolk";"Chesapeake";"Richmond";"Salisbury";"Falls Church"

This works, but I'd rather it pull from a table so it can auto populate by
entering data into just one field.

Thanks,

-Charles-