Quick Qestion RE: IIF

[NewShoes]

Quick Question RE: IIF

Hey all,

I'm sure this is fairly easy but I'm not sure where to start...

I basically need a to display a text label on a form when a check box (on the same form) has a been ticked. I also need the text label to hide when the check box is unticked.

Any advice would be great!
-NS

 

[MStef]

Look at "DemoLabelA2000.mdb" (attachment, zip).

 

[NewShoes]

Fantastic MStef, many thanks!

I have one more question which you may be able to help with...

Basically, I'd like to have a Main form that contains a subform. I would to have 2 boxes on the main form that I could enter 2 dates in (start date and end date). I would like the subform to display records which fall between the 2 dates specified in the main form. Is this possible? (or possible without too much coding?)

Many thanks,
NS

 

[gemma-the-husky]

very little coding

in the query driving the subform put criteria for the date as

between fromdate and todate

(where fromdate and todate are the fields on the from) - (you will have to look up up syntax for referring to them)

then, as an example, have a button that just does the command

subdetails!requery
(where subdetails is the name of the subform control, on the mainform - not the stored name of the subform - although it may be the same)

you could amend this to call this command from afterupdate events of the data fields - depends how interactive you want it. You also need to consider how you want to deal with blank datea.

note that between operator does not care about the order of the dates.

 

[MStef]

Yes, it is possible, you don't need 2 forms for this. It's enough 1 form.
Look at "DemoDateBetweenA2000.mdb"
Open form and try.

 

[NewShoes]

Many thanks Dave and MStef, that is a great help!

I believe I can use this http://www.mvps.org/access/forms/frm0031.htm for the syntax of referring to a control in a query?

Thanks,
NS