combo box in subform?

[shumate62]

So I'm creating an address book for an annual event and made one table that
had the basics (name, address, phone) and then a table for the 'group' that
that person was a part of one year to the next (one year that person may have
been the speaker, the next year an honoree, and the third year maybe just an
invitee, so I had created a third table as the linking between PersonID and
GroupID with a year field as well.

My plan was to have the basic address part on the top of a form and then a
subform below with a combo box that allowed for those groups to be selected
and then separate- but next to that the year would be selected (so dropdown
and select Speaker and then tab over and put in 2007, then click down to the
next combo box and select Honoree and tab over and put in 2008, etc..) and
with the expanding combo boxes this list could be used for ten years.

I am stuck though, I have the PersonID and the form for that but my combo
boxes are always flawed and I have read every thing on the help menu but none
of it's troubleshooting what I'm thinking might be a relationship problem?

 

[John W. Vinson]

So I'm creating an address book for an annual event and made one table that
had the basics (name, address, phone) and then a table for the 'group' that
that person was a part of one year to the next (one year that person may have
been the speaker, the next year an honoree, and the third year maybe just an
invitee, so I had created a third table as the linking between PersonID and
GroupID with a year field as well.

My plan was to have the basic address part on the top of a form and then a
subform below with a combo box that allowed for those groups to be selected
and then separate- but next to that the year would be selected (so dropdown
and select Speaker and then tab over and put in 2007, then click down to the
next combo box and select Honoree and tab over and put in 2008, etc..) and
with the expanding combo boxes this list could be used for ten years.

I am stuck though, I have the PersonID and the form for that but my combo
boxes are always flawed and I have read every thing on the help menu but none
of it's troubleshooting what I'm thinking might be a relationship problem?

We'll need more information I fear.

What ARE the relationships? What's the primary key of each table? What's the
relationship? What are the Recordsources of the mainform and subform? What are
the Rowsources and Control Sources of your combo boxes?

 

[JESS BLAKLEY]

So I'm creating an address book for an annual event and made one table
that
had the basics (name, address, phone) and then a table for the 'group'
that
that person was a part of one year to the next (one year that person may
have
been the speaker, the next year an honoree, and the third year maybe just
an
invitee, so I had created a third table as the linking between PersonID
and
GroupID with a year field as well.

My plan was to have the basic address part on the top of a form and then a
subform below with a combo box that allowed for those groups to be
selected
and then separate- but next to that the year would be selected (so
dropdown
and select Speaker and then tab over and put in 2007, then click down to
the
next combo box and select Honoree and tab over and put in 2008, etc..) and
with the expanding combo boxes this list could be used for ten years.

I am stuck though, I have the PersonID and the form for that but my combo
boxes are always flawed and I have read every thing on the help menu but
none
of it's troubleshooting what I'm thinking might be a relationship problem?

 

[shumate62]

I'm sorry John- you were helping me before with your database, but I'm stuck
because I don't have the skills to tweak your database so I was trying to go
back and recreate mine based on your inspiration but was getting stuck on the
combo boxes-

 

[John W. Vinson]

I'm sorry John- you were helping me before with your database, but I'm stuck
because I don't have the skills to tweak your database so I was trying to go
back and recreate mine based on your inspiration but was getting stuck on the
combo boxes-

Got your email, will discuss offline.