Access Forms

[JamieWilks]

Hi I'm currently building a daabse in MS Access 2000, having not touched access for about 10 years. I need to conditionally hide / display a combobox (specfically a pop up calendar) depending on the answer to the previous combobox.

I only want the date box to be displayed if the answer to the previous field was 'Pass' currently I have this code:

Private Sub Field1_BeforeUpdate(Cancel As Integer)
 
If Me![Field1] = "Pass" Then
Me![Field2].Visible = True
 
Else
Me![Field2].Visible = False
End If
End Sub
 

I've also set the visable format option to 'No' this works fine the first time the data is entered but if you look at the form again the field is hidden. I've got a feeling that the anser is simple but I'm still finding my feet in VB.

Thanks for any help

J

out of interest, I'm going to be building databases more often now would you guys / gals reccomend a book on Access or a book on VB? or both?

[Rabbit]

You also need the code in the On Current event of the form.
As for books.. I use the Access help files, they're really good.

[missinglinq]

First off, depending on how long your memory is, you might want to invest in an Access for Dummies type book. People may laugh, but one of the biggest problems we see here and on other forums is that the people posting questions don't know the names of the objects or even the most basic procedures, and so can't post a question/problem so that it's understandable. An hour or two paging thru one of these books will probably stir up memories from your previous experience and give you a good foundation. And as programming texts go, they're dirt cheap!

An excellent book I just came across is called Fixing Access Annoyances (O'Reilly Media, Inc.) by Phil Mitchell & Evan Callahan. Mitchell is the lead analyst/programmer for Harvard University and Medical School, and still manages to write in a very down to earth, understandable manner! This book is about 350 pages and is nicely indexed for quick referencing, and does exactly what it's name suggests, tells you how to avoid the many pitfalls and fix the aggravations caused by Access' quirkiness, and in the process develop and run better apps! It's a real steal at 19.99 USD.

And lastly, spend a few minutes everyday looking at the questions posted here and look at the tutorials our members have posted! You'll learn a lot, and before you know it, you might find yourself answering questions!

Welcome to TheScripts!

Linq ;0)>