Pop-up form Control Sources?

[hawornk via AccessMonster.com]

Okay, as a relative beginner in Access, I’m not sure how to word this
question, and if more background info or clarification is needed in order for
me to get a helpful answer, please let me know. Here goes:

I have a database of questions and answers. Each record (question and answer)
can have between 1 and 8 citations associated with them. The citations come
from an approved list, and I have that as a separate reference table. In the
main question/answer table, the citations are formatted as lookup fields.
Because of the text limitations in lookup fields, I created two columns in
the reference table – CitationShort (author/year only) and CitationLong
(author/year/title/etc.). I managed to set things up so users select from
CitationShort in the Lookup field, and CitationShort is what appears in all
the relevant forms during the record entry/selection process (necessary due
to space constraints) but CitationLong is what prints in reports. This works
great.

The catch? I have a form where users select what records they want to print
in their report, with CitationShort info appearing in the citation fields.
Users want to be able to click (double-click?) on any of the citation fields
on the form and have a pop-up window appear with the associated CitationLong
data. Is this possible? Do I need to make 8 separate pop-up forms, or is
there a way to change the ControlSource for the text box on the pop-up form?
Does this even make sense?

 

[Guest]

The very first thing you should do is get rid of the lookup tables. They
will cause you no end if grief in Access.
The filtering you want to do is best done with cascading combo boxes. You
will get more on that than you can read if you Google "Cascading Combo Boxes".
Use that technique to do your filtering.

 

[hawornk via AccessMonster.com]

I'm not sure I understand. How is a combo box different than what I'm doing
and how will it help me?

Here's what I need:

Each record can have up to eight citations associated with it. They are
pulled from a list of 214 possible citations. So, for a particular record,
Citation1 would appear as "Hawornk, 2007" (CitationShort), but when it goes
to print it will appear as "Hawornk, K. MS Access: Understanding Combo Boxes,
Access Weekly, S2007; pp7-22" This setup needs to be potentially repeated
for seven more citations.

So, when they're looking at the form the Citation1 field will say "Hawornk,
2007" but when they double-click on it, I want them to see a pop-up form that
says "Hawornk, K. MS Access: Understanding Combo Boxes, Access Weekly, S2007;
pp7-22" Likewise for citations 2-8.

The very first thing you should do is get rid of the lookup tables. They
will cause you no end if grief in Access.
The filtering you want to do is best done with cascading combo boxes. You
will get more on that than you can read if you Google "Cascading Combo Boxes".
Use that technique to do your filtering.

Okay, as a relative beginner in Access, I’m not sure how to word this
question, and if more background info or clarification is needed in order for

[quoted text clipped - 19 lines]

there a way to change the ControlSource for the text box on the pop-up form?
Does this even make sense?

 

[Guest]

For starters, read the info here
http://www.mvps.org/access/lookupfields.htm

Combos are designed as a lookup control. That is what they do best.
--
Dave Hargis, Microsoft Access MVP

I'm not sure I understand. How is a combo box different than what I'm doing
and how will it help me?

Here's what I need:

Each record can have up to eight citations associated with it. They are
pulled from a list of 214 possible citations. So, for a particular record,
Citation1 would appear as "Hawornk, 2007" (CitationShort), but when it goes
to print it will appear as "Hawornk, K. MS Access: Understanding Combo Boxes,
Access Weekly, S2007; pp7-22" This setup needs to be potentially repeated
for seven more citations.

So, when they're looking at the form the Citation1 field will say "Hawornk,
2007" but when they double-click on it, I want them to see a pop-up form that
says "Hawornk, K. MS Access: Understanding Combo Boxes, Access Weekly, S2007;
pp7-22" Likewise for citations 2-8.

The very first thing you should do is get rid of the lookup tables. They
will cause you no end if grief in Access.
The filtering you want to do is best done with cascading combo boxes. You
will get more on that than you can read if you Google "Cascading Combo Boxes".
Use that technique to do your filtering.

Okay, as a relative beginner in Access, I’m not sure how to word this
question, and if more background info or clarification is needed in order for

[quoted text clipped - 19 lines]

there a way to change the ControlSource for the text box on the pop-up form?
Does this even make sense?