Access 2000 combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a combo box titled activity that I would like to use more than once in
the same row. When selected, this combo box will auto-fill other fields.
Each row represents a days worth of activities. I would like to use the same
combo box titled activity multiple times in the same row. When I pull the
same field it pulls the same data entered in the first activity.
 
I have a combo box titled activity that I would like to use more than once in
the same row. When selected, this combo box will auto-fill other fields.
Each row represents a days worth of activities. I would like to use the same
combo box titled activity multiple times in the same row. When I pull the
same field it pulls the same data entered in the first activity.
Click to expand...

What's the structure of your Tables? Never mind about the form or the
user interface for starters - until you have your table structure
properly normalized, it's premature to worry about forms or code.

It *sounds* like you want to store multiple activities in (several
fields?) in the same record. If so, *your table structure is
incorrectly normalized*. You should not store multiple "things" in a
single row, ever; if you have a one to many relationship betweed nays
and activities, you need *ANOTHER TABLE* to contain the day's
activities. On the Form you would use a Subform based on this table to
enter the activities - and there, you would have a single combo box,
shown on multiple rows, and would just select as many activities as
you need.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top