Continuous Forms

[livvie]

Don't know if this can be done or not but hopefully somebody can help.
I have a continuous form with a select button on it that puts the data from that record into another form and table. I would like to be able to show that I have selected that record by either changing colour or something like that.

 

[WayneRyan]

livvie,

You can make an "unbound" control on your form and use Conditional
formatting to make the record appear different. If you have A2K
or higher.

Wayne

 

[livvie]

what condition would I need to check for

 

[WayneRyan]

livvie,

Kind of hard to say without seeing it, but here's an example:

Your form has three fields:

PersonsName - Text
PersonsAge - Number
SelectionStatus - CheckBox

Initially, assume that all SelectionStatus fields are false.

On your form, select the PersonsName field, go to Format --> Conditional

Choose "Expression" and put: [SelectionStatus] = True
Then make the PersonsName Bold, or red or whatever.

Then on your button, just put Me.SelectionStatus = True and the
person's name will change.

That's the general idea.

Wayne

 

[Rich]

just curious, why would you want to store the same information in more than one table?

 

[livvie]

going from quote to estimate to contract etc just picking bits and pieces from multiple tables to make new rec in other table. Mostly id's etc that get passed to allow links to other tables. I'll try that.

 

[livvie]

Rich
This doesn't work I'm afraid. I'm getting the error method or data member not found