show either result or text "in Workshop" in query in form (URGENT!)

  • Thread starter Matthew Pilkington via AccessMonster.com
  • Start date
M

Matthew Pilkington via AccessMonster.com

I need help urgently
I need to run a query in a subform if there is a result (There will be only
one) i need to show that if there is no result i need to show on the form
somewhere the text "In Workshop"

If any one can help it will be much appreciated

thanks
Mat
 
M

Michel Walsh

Hi,



If Me.SubFormName refers to the control name, have two forms,
FormWith and FormWithout, the first one with the controls disposition when
information is available, and FormWith a form having the same size than
FormWithout, but with only a label in it, with the desired message (In
Workshop). Then, once the inquery can be done, proceed a little bit like:

If 0 = DCount("*", ...., ... ) Then
Me.SubFormName.SourceObject="FormWithout"
Else
Me.SubFormName.SourceObject="FormWith"
End If



that is, the appropriate form is displayed, accordingly if there is no
record, or not, in the "subform" control.


You may have to re-edit the parent-child link, if any.



Hoping it may help,
Vanderghast, Access MVP
 
Top