Combobox with Dlookup in Datasheet View

I have created a combo box on a datasheet view form that does 2 things: it uses a dlookup to get the initial data (an employee name) then it has a row source to a query. The strange thing that happens is that when I open the form, the first name appears, and all subsequent records have missing entries (the rest of the data does show up). When I either click the mouse anywhere or hit any key, the remainder of the names magically appear. I tried sending keys to try to get the form to show the data, but that does not work.

Any ideas how to make my data show up when I open the form?

re: Combobox with Dlookup in Datasheet View

hi jad,
I have no idea if this will work, but you could try putting a requery event on the combobox after it loads, see if that fixes it up. Otherwise, one of the experts might have an idea :)

Good luck!

theAybaras

re: Combobox with Dlookup in Datasheet View

I have tried that too, but it did not help.

I have also seen this behavior on some other forms, so maybe it is something in Access 2000 (like the way the scroll bars don't always initially show up).

I hope someone out there has an answer!

re: Combobox with Dlookup in Datasheet View

It sounds like your combobox is an unbound control. That is it is not tied to any field in the table or query behind the form. Because of this it is changing based on the record in focus. As you are using it in a datasheet it will change in all records each time it changes.