Recent content by TonTon

Is Combo66 actually bound to the field with text or to a numeric field? If its bound to a numeric field then your condition would give a type mismatch.

Which section have you put the "average" control in?

You can refer to them in your report by setting the ControlSource of a text box to: =Forms![FormName]![ControlName] FormName is the name of your form. ControlName is the name of the control on that form. Hope this helps Tony

What's the error that's displayed? What version of Access are you using? I am still using v2, but have read some of the documentation on "What's New" in later releases. I think that in one of the versions after v2, the IsNull function changed. Hope this is of some help Tony Actually...

Insert your Select Case statement into the AfterUpdate event of the text/combo box (etc), which decides availability of other boxes. eg If you have a field Married(Yes/No) and you only want your MaidenName text box to appear if the user selects YES for Married, then insert the code into the...

Ensure the records are ordered as you wish. Create a Text Box in the header or footer of the item you wish to rank, eg in the [StoreID] header. Set the ControlSource of the Text Box to: =Count([StoreID]) This will only count one store per header. However, if you set the RunningSum property...

I don't know if this answers your problem, but you can base queries on other queries, not just on tables. ie I think that what you are trying to accomplish, as detailed in your data flow diagram, can be done in one query; which may require sub-queries. Therefore, when handling the user request...

You can use the OnCurrent event to set whether the current record's fields are locked/enabled. When you click into a different record the OnCurrent event will run again. Hope this helps; cheers

How about another option.... allow the user to select the employee (whose name should be displayed) from a combo box (called cmbEmployee) on a form (called frmSelectEmployee). Then in your query which feeds the report (or the report, itself) have a calculated field such as: in query -...