I need help with combo boxes & lookups in Access, please?

[Guest]

I'm trying to create my first database. I'm working on a form right now that
will display data from several fields, all of which now have seemingly stable
relationships. Their all basically related to one field which has the key
lookup information. It's for my Bible studies and the lookup field goes by
Genesis 1:1 or Micah 2:2, etc.. On my form, at the bottom, I can tab through
passage after passage in correct order all the way through. However, I want
a combo box that I can type in the passage I want and go straight to it. How
can I do this please!

Married Mark

 

[Arvin Meyer [MVP]]

Try setting the wizard button to on (In the form's design view, open the
toolbox (turn it on from the view menu) and click on the wand icon to select
it) drag the field from the field list (also turn it on from the view menu)
to the form and the wizard will pop up and walk you throught the steps and
write code for you.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Okay, I'll try it. Be back in a few.

Married Mark