How to create a "living form"

[BiotechAccessUser]

Hi,



I am new to Access and may be missing an obvious solution. I have a sample code field for data entry on a form, which is in a dropdown list. I want the first form the user sees to have just the sample id, the sample code (date, initials etc), but once they select the sample code, depending on the code, I want other fields to become visible. How do I do this?

Thanks!

[pbaldy]

This type of thing?

http://www.baldyweb.com/ConditionalVisibility.htm

[BiotechAccessUser]

Yes! So do I just try and put this into the Macro part of Access? I have never done this before. I will try and ask if I have questions....

This type of thing?

http://www.baldyweb.com/ConditionalVisibility.htm

[BiotechAccessUser]

Hi,

I tried the following code:

Dim SampleCode As AcControlType
Dim pH As AcControlType
If SampleCode = "LLS" Then
pH.Visible = True
Else: pH.Visible = False
End If

I can't seem to dim the field as a field....is AcControl not right? also what if my field name has a space in it?

Thanks!

[pbaldy]

Why don't you simply refer to them as I did in the link? Also, I'm not personally a fan of mixing the one-line and block formats of an If/Then/Else.

[BiotechAccessUser]

Thanks, but what do I do with a control name that has a space in it (like "Sample Code")? And I don't know the difference between one-line and block formats, I'll have to look it up! I'm a beginner self taught coder (if you can even call me that). Thanks!

[pbaldy]

If you have inadvisable spaces in your names, they need to be [bracketed].