Access - Updata combo box in form with data from table.

M

mandy_frog

I have already set up combo boxes on my data entry form. What i would like to
do is have the lists show all values in the database already, and list new
data as they are entered. So that if a user is entering data, the data
entered immediately appears in the combo box for the next data record. Why is
this so hard to do? Is there any chance of access becoming logical and user
friendly anytime this century? Thanks
 
R

Roger Carlson

You need to requery the combo box after each record is saved. So in the
AfterUpdate event of the form, put something like this:

Private Sub Form_AfterUpdate()
Me.Combo1.Requery
End Sub

(Replace "Combo1" with the actual name of your combo box.)

BTW, you will get more help here if you don't complain about Access. Many
of us have worked with it for many years and know it to be logical and
user-friendly. Just because you don't know how to do something, don't blame
Access.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Top