Form to show up with specific criteria

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PJ - 23 May 2007 22:39 GMT

I have a control source named" loan type" which is in a form named "frm
general Infromation subform". If any data in that control source equals
sd-re, sd-cb, sd-cm, sd-re-sag, sd-cb-sag, or sd-cm-sag then a form would
show up named "frm call notes document tickler input subform" in a form named
"document tickler input". Otherwise is would not be visable. How would I
code that? thanks!!!

Reply to this Message

scubadiver - 24 May 2007 11:21 GMT

Is your control source a combo box?

You haven't given more details so my personal suggestion is that, if you do
this, then you can based the options on a look up table with two columns.

Column 1: Letters
Column 2: a number to distinguish the ones you need (say 0 or 1).

In the combo box use the table as the source. Make the bound column the
first column and make the second column invisible.

In the after update event:

If [control].Column(1) = 1 then [forms]![main form]![subform].visible = True

You may have to mess around a bit to get it right.

Signature

http://www.patriotsquestion911.com
http://www.911truth.org
http://www.wtc7.net
http://www.st911.org
http://www.journalof911studies.com
http://www.pilotsfor911truth.org
http://ae911truth.org

> I have a control source named" loan type" which is in a form named "frm
> general Infromation subform". If any data in that control source equals
> sd-re, sd-cb, sd-cm, sd-re-sag, sd-cb-sag, or sd-cm-sag then a form would
> show up named "frm call notes document tickler input subform" in a form named
> "document tickler input". Otherwise is would not be visable. How would I
> code that? thanks!!!

Reply to this Message