Continuous subform/control visibility question

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

Guest

Okay, here goes.

Access 2002. I have a conctinous subform with several controls on it (text
boxes and a combobox). I ONLY want the combobox visible on the NEW RECORD
instance of the subform (the one at the very end of existing data). Is there
a way I can specify that? Right now, my conditionals make the combobox
visible on ALL instances of the subform, when that's not what I want.

If a person is going to enter a NEW record, I want them to see the combobox,
else not. That control allows them to select a data value for insertion into
the record. It is NOT bound to the form itself, but to a stand-alone query
used to populate it.

Any thoughts?

Thanks!
 
Worked perfectly, thanks!

However, it still shows the control in all previous instances of the
subform. I wish it would ONLY make it visible in that VERY LAST instance of
the subform.

But it also gave me some ideas for a popup for, rather than a control on the
subform.

Thanks a million!
 
Dennis said:
Access 2002. I have a conctinous subform with several controls on it (text
boxes and a combobox). I ONLY want the combobox visible on the NEW RECORD
instance of the subform (the one at the very end of existing data). Is there
a way I can specify that? Right now, my conditionals make the combobox
visible on ALL instances of the subform, when that's not what I want.

If a person is going to enter a NEW record, I want them to see the combobox,
else not. That control allows them to select a data value for insertion into
the record. It is NOT bound to the form itself, but to a stand-alone query
used to populate it.
Click to expand...


You can't get that effect without jumping through some
hokey hoops.

If you can settle for Enable instead of Visible, you can use
Conditional Formatting. Just setcondition1 to:
Expression Is Not Form.NewRecord
and turn off the Enabled property.
 
Back
Top