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

  • Thread starter Thread starter Matthew Pilkington via AccessMonster.com
  • Start date 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
 
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
 
Back
Top