Refresh list!

[Gaylord]

Hi,

I have a form that requires the user to import some data from an oracle database into an access table.

This is controlled by a simple form that when I press "import" it pulls all the required information from the database accross. This bit works fine.... However the next step requires them to pick a value from a drop down list, this doesn't seem to refresh. The only way I can get values to populate it is through closing and reopening the form, which is far from ideal....

Anyone got any ideas???

Thanks in advance

Jamie

 

[Mike555]

Read about the requery function in the Access help file.

HTH

--
Mike

 

[TheAceMan1]

How are ya Gaylord . . . . .

[blue]Me!ComboboxName.Requery[/blue]

See Ya! . . . . . .