[Visible] property for SetValue in macro

[truckdispatch]

HI, I created a form to enter report criteria following the example from MS access help.

the form pops up and requests you enter a date, after which you click on an OK command button. Clicking that button is supposed to pull up my report (based on a query that uses the date that you just entered).

i know this has worked before (slightly altered, plus on a different version of ms access), but every time i click ok, the computer pops up telling me that

"You entered an expression that has an invalid reference to the property Visible." then, it says something along the lines that the property may not exist, or something like that.

please be advised I don't know the first thing about ms access!!!! i don't know how to program or anything AT ALL! and I have only managed to design simple databases by trudging through confusing help files and using wizards. can someone help me?

(just do a help search with the text "use a form to enter report critiera" and you'll see the Help file example that I have been using)

 

[truckdispatch]

Hi everybody, I thought I might come back and elaborate on my problem, maybe someone can help? I appreciate your patience.


This is the situation:
Basically, I was trying to build a Teacher Contacts (An address book, more or less) database for my mom.

As part of her job, she needs to meet individually with a huge amount of teachers at least once a year. So I created a table&form for her, with the teacher's name, home school, subject they teach, etc. etc. Also in this form, I added a field for "Last Meeting Date".

I wanted a way to have access prepare a report listing all teachers whose "last meeting date" is over a year old. I'm not very good at this, I don't know how to program query criteria, and could not figure out how I could create criteria such that the report will automatically list these teachers last met over a year ago from any given point in time. For example, if I pull up the report today, the query will automatically look back a year from THIS date, or tomorrow, a year back from tomorrow's date, etc etc. (I hope this makes sense, I'm not very good at explaining.)

Well, like I said, I really bumbled that one, I couldn't figure how to do it. So, I did some searching through MS Access help, and came upon the example you see in the post above. I tried to follow the example as best I could, though not everything quite applied, and there resulted in a lot of quirks.

I figured I would make a form, such that whenever my mom would want said report, the form would pop up, and ask for a "CutoffDate". Any teachers whose last meeting date is before (or older) than this cutoff date, the report would display.

Unfortunately, whenever I click OK on this "Last Meeting Date Criteria" cut off date, I get the error message you see in the post above. I really don't know what it means, I was just copying the example from MS Access, so I don't know how everything is related. Maybe my query syntax is wrong?

I wrote something like

<= [Forms]![Last Meeting Date Criteria]![CutoffDate]

I was trying to follow the example criteria from MS Access's help file, but the criteria is really different, and I was just kind of guessing at how it should look.

is that syntax ok? am i missing something? or does someone know an easier way? If i know very little about Access (which I know VERY LITTLE), my mom knows about 100 times less. I just wanted to make a switchboard where she could pop up this report with the touch of a button.

Even when I press the Cancel button on my form, that messes up too, and brings up a parameter prompt that I need to manually close again. But that, I can live with. I basically can't get my report to pop up at all.

Please, everybody! I know I'm a newbie, and would be a hassle to work with, but I would appreciate your help SO MUCH!