Making Acess form fields invisable

[oggsta]

I have teh following code shown below that works fine, however the feild client has been moved to a differenet table named [Main]; as oposed to [Feild1] which is located in the table named sheet1, hence i need to change the syntex of the top line to enusre that this script will work. Any ideas on the changes required will be apreceiated?

Ie Select Case (Form Main) Feild Client
As opposed to
Select Case Me!Client

The Full SCRIPT CAN BE SEEN BELOW

Select Case Me!Client
Case "CPS"
[Feild1].Visible = True

Case Else
[Feild1].Visible = False

Thanks

 

[jrbarnett]

With the mixed references to cells and sheets (implying Excel) and tables (implying Access) I am wondering which product you are using to host your application. The following demonstrates how to do it in Access. Perhaps an Excel VBA expert would give the equivalent for a spreadsheet.

Select Case Forms!Main!Client
Case "CPS"
[Feild1].Visible = True

Case Else
[Feild1].Visible = False
End Select

--
John