continuous differing forms

  • Thread starter Thread starter Thomas Spellman
  • Start date Start date
T

Thomas Spellman

How would you go about displaying a list of forms, some with textboxes, and
some with dropdowns, depending on a boolean in the recordset? Is it
possible to hook into the subform code to show your own continuous list of
forms and choose which form to use according to your code?

T
 
Thomas said:
How would you go about displaying a list of forms, some with textboxes, and
some with dropdowns, depending on a boolean in the recordset? Is it
possible to hook into the subform code to show your own continuous list of
forms and choose which form to use according to your code?
Click to expand...


I have no clue what you're talking about, but you might want
to look into setting the subform's SourceObject property.
 
Is it possible to have some code run on every iteration of the detail
section of a continuous form that only affects the controls on that one
iteration?

I'd like to have some code run on each iteration that reads the values in a
control or field and makes another control on that one iteration visible or
not depending on its value. When I tried this it made all instances of that
control invisible on ALL iterations of the form. Is there a way to limit it
to just the current iteration?

T
 
There are only a few things you can do to each record
displayed on a continuous form. Unfortunately, manipulating
the Visible property is not one of them. Without getting
into some convoluted combinations of controls and VBA code,
about the best you can do is use the
Format - Conditional Formatting
menu item to disable the control.
 
Back
Top