Combo box set up

[Guest]

I want to be able to look up information from a table in forms for microsoft
access. I used a combo box to do that and it isn't working. I didn't use a
Customer ID in my set up is that what is causing the information to not show
up?

 

[John Vinson]

I want to be able to look up information from a table in forms for microsoft
access. I used a combo box to do that and it isn't working. I didn't use a
Customer ID in my set up is that what is causing the information to not show
up?

Presumably because you set it up wrong in some way.

However, since we cannot see your computer and have no idea what you
did, it's more than a bit difficult to say what you did wrong!

Some specific questions:

- What's the Recordsource of your Form? Please post the SQL if it's a
query.
- What's the Row Source of the combo box? Ditto.
- Do you have any VBA code in the combo's AfterUpdate event (the usual
way to find a record on a form)? If so please post it.


John W. Vinson[MVP]