How to make a lookup. 1

[Dontremb]

Ok, I've got a form with subforms and stuff in it... The main problem is this:

The combo box wizard won't allow me to make a look up.

Someone mentioned that it's possible I don't have the database normalized, but I read all the rules before and since, and I THINK I'm following at least 1-3 normalization rules.

Unfortunately, I'm not savvy enough to know the code or whatever to create my own lookup. I don't suppose someone could give me a breakdown?

Ultimately, I know it's pretty easy: Select name from combo box, after update = search records, then, somehow find the record I want, and tell the form to go to that record.

I just don't know the syntax. Any help would be appreciated.

 

[MajP]

Spend some time in the FAQs section. Look under combo boxes. There is a faq on using combo as navigation tool.

 

[Dontremb]

Thank you.

 

[Dontremb]

MajP,

Thanks so much. I used the FAQ and it worked perfectly. I don't understand it completely, but I would rather it worked now, and I'll figure it out later.

Thanks again.