combo box 'dynamic' row source question

I've created a form which contains 2 fields:

1st field is a textbox called get1st,
2nd field is a combo box called get2nd

The source for get2nd comes from a single column table called table1 whos only

field is called field1.

The value input in the get1st field alters the rows in the table table1 (code on

get1st afterupdate).

The combo box options on get2nd are correct intially (when a value is 1st

entered into get1st), however....

when get1st is then updated, the combo values still retain their original

values.

Is there anyway of forcing get2nd to use the current values stored in the table

table1, rarther than an intial snapshot?

Found out whats needed just added

Me.Requery

To the last line of the afterupdate code of get1st, nice and simple!

edit: its better to use <fieldname>.requery, as this only recreates the combo box's list options and will not cause any possible record locking