updating combo box

  • Thread starter Thread starter nicandro via AccessMonster.com
  • Start date Start date
N

nicandro via AccessMonster.com

hi
how do i get a combo box to update the data in my form when i select
somthing in it (in access 2003)?
 
I am wondering if you mean update data or if you mean select data. If you
have an unbound combo box on your form and then have your form based on a
query where the unbound box is in your criteria. Then on the After Update
property of your combo box put
Me.Requery

You can also use the Recordset Clone function but the above is easier.

If you want it to actually alter your data, then you will need to give us
more info as to what you are trying to accomplish

Jackie
 
hi

to be more specific i meen i need a combo box that when i select somting in
it it will bring up all the all the related data that goes with the piece
of data selcted in the combo box.

from nic
 
Then use my above suggestion if you can base your form off a query. The
combo box would be unbound (named like: FindCustomer) and then referred to
in your query criteria like:
Forms![frmInputEntry]![FindCustomer]

Use the expression builder to point to the correct unbound field

Then requery on the After Update of the FindCustomer combo box.
 
Back
Top