Advice on populating text boxes.

[Devorummortis]

Hello,

I'm VERY new to Access, and am building a database to track
appointments for the squadron I work for. They want to be able to
pull up any appointment for anyone in the squadron.

So far I have a combo box to choose the flight, which then enables a
second box containing only the members of that flight, so they don't
have to search through 500 names. This is where my problem begins. I
want to have the choice in the second combo box populate two text
fields: One for their name, the other for their workcenter
information.

I've done several searches through these groups, and spent some time
looking for how to do it in the access program itself, but have come
up empy. Can anyone here help me out?

 

[Arvin Meyer [MVP]]

The following sample may help you:

http://www.accessmvp.com/Arvin/Combo.zip

 

[Devorummortis]

The following sample may help you:

http://www.accessmvp.com/Arvin/Combo.zip
--
Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com









- Show quoted text -

the form itself won't open in form view, and I can't see what I'm
supposed to be looking for in design view. If it helps, I'm using
access 2003.

 

[Arvin Meyer [MVP]]

The following sample may help you:

http://www.accessmvp.com/Arvin/Combo.zip

the form itself won't open in form view, and I can't see what I'm
supposed to be looking for in design view. If it helps, I'm using
access 2003.