Lookup field not showing latest data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a table of people (7 info fields) that changes periodically (additions
and deletions). one of the fields is used as a drop-down box on a data entry
form so the user(s) can pick the person by name and it inserts their ID# into
a different table. why is it that when i update the tblPeople, the changes
show up when i view the tblPeople itself but not the in the drop-down box on
the form?
thanks for the help!
 
in case you were curious, i solved the problem. instead of basing the
combobox on a field in the BE table, i based it on a query of that field.
works like a charm. helps to get out of my cave and take a walk once in a
while!
thanks again for your help, your suggestions actually triggered the answer
for me.
 
You must log in or register to reply here.

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

Lookup field 5
List Box Problem 2
Access 2007 - Table A lookup values based on Table B 1
Unique ID and Latest Date 5
140 Fields on a single Record - or What ? 5
Relationships getting redefined? 3
Data Entry to Form with repeat data. 13
duplicating records that contain subforms 2

Back
Top