Continuous Forms

[LadyDi]

I have a quick questions regarding Continuous forms. I have a continuous form that shows approximately 20 records. Those records all have a field that shows whether or not a discount was approved for that customer. If the discount was approved for the customer, I would like a note to appear, otherwise, I do not want anything special to appear. I put code on the On Current event of the form, but that does not do what I would like it to do. That takes the note (or lack there of) for the current record and copies it on every record. How can I get it so that the note is specific to each record, whether it is the record of focus or not?

 

[boblarson]

That is a difficult task as the unbound control is just a copy propagated over the number of records. So, you could use a popup form to display the note for that record or, if short enough you could use the control tool tips (although not likely the best).

Or you could have a text box at the top or bottom (in header or footer) that you populate with the contents in the on Current event.

 

[LadyDi]

How would I go about getting the pop up form?

 

[boblarson]

How would I go about getting the pop up form?

So are you trying to ADD a note to a transaction or trying to display one?

 

[Mike375]

Would it be easier to have a field in your query based on IIF etc and the result could be "ths person is approved" or a Null and then perhaps add conditional formatting.

 

[shadow9449]

Is this note stored in the underlying table? If so, then why don't you just add it as a field to the form?

 

[LadyDi]

I want to display a note that is not housed in my table.

 

[Mike375]

If you put a macro or code to open the Note/Form on OnCurrent and have a condition there it should work, assuming you have some sort of ID to have the correct note open. In other words the form will open when you scroll the records if the condition is met.

But personally, I would rather have conditional formatting colour a field in the record and then put the macro or code to open the form on OnClick.

 

[missinglinq]

What kind of control determines whether the discount is approved or not?

Are you talking about the same message for all customers with approved discounts?

 

[allan57]

In the control source of an Unbound text box add your criteria there i.e.

=iif([discount was approved for that customer]=true, "Discount approved", "")

Replace '[discount was approved for that customer]' with the appropiate field.

 

[LadyDi]

The control that determines the note, is a text field.
The unbound text box that Allan57 suggested works great for the note. I have one more question. Is it possible to make a button appear and disappear based on this unbound text box? There is a listing that will show the person exactly what discounts that customer is approved for. So, if the customer was approved, I would like to have a button appear that will take the person to the detailed listing.