Need help with form

  • Thread starter Thread starter ladyllbug
  • Start date Start date
L

ladyllbug

On my form, I want to show transmission information if the account has a
transmission. I am new at this. The transmission is a Yes / No field on the
table; the transmission details are in a separate table. I only want the
information to appear if the account has a transmission associated with it.
I tried a subform, but it appears whether the transmission is checked or not.
Can someone help?

Thanks.
 
On my form, I want to show transmission information if the account has a
transmission. I am new at this. The transmission is a Yes / No field on the
table; the transmission details are in a separate table. I only want the
information to appear if the account has a transmission associated with it.
I tried a subform, but it appears whether the transmission is checked or not.
Can someone help?
Click to expand...

What sort of "transmission" - automotive? truck? sending a message?

And what sort of table structure: do you have a Yes/No field for each kind of
transmission?

More details please!
 
ladyllbug,

While Steve has provided code that will accomplish the task of making the
sub form to be visible or not based on the value of the Yes/No field,
"transmission", I would suggest that you create a function and place the code
that Steve provided in that function. Then call the funciton from the On
Current event of the form and from the After Update event of your check box
for the "Transmission" field. This way you only have the code in one place
but you can call it from multiple places.

-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm
 
Back
Top