Subform on Continuous form workaround?

  • Thread starter Thread starter Phil Hellmuth
  • Start date Start date
P

Phil Hellmuth

Apparently, Access doesn't allow use of subforms on a continuous forms. Are
there any workarounds to this? I tried replacing the subform with a textbox
and, on the Form_Current event, populating the textbox with the results that
otherwise would have appeared in the subform. However, the textbox is
populated on every row on the form. So, I need something else. Is what I'm
trying to do possible?

Thanks in advance.
 
Hi, Phil.

Please describe in generic terms what you're trying to represent, i.e., the
relationship between the records on the continuous form and the subform,
their record sources, etc., and I'm sure someone can help advise you.

Sprinks
 
Albert,

Thanks a lot for that enormously informative link. Paraphrasing Bobby
Jones, speaking of Jack Nicklaus, "You play an Access with which I am (until
now) unfamiliar."

Great post.

Sprinks
 
OK, here's the data representation:

I have a continuous form to list Airport Codes. In addition to detailing
data related to the Codes, I also want to display the Flight Numbers for
flights that originate from the Airport Code. For example:

Airport Code Flight Nbrs Airport Name International?
-------------- ------------ -------------- -------------
ABC 123 Podunk No
456 Airport

DEF 789 Airports 'R' Yes
Us
 
Using Albert's strategy, however, I can only display the Flight Numbers for
the selected Airport Code, as opposed to viewing all the Flight Numbers for
all the Airport Codes at once, correct? Not optimal, but my client can
probably live with it.
 
Back
Top