Continous forms on format ? (2000)

Topic

New Reply

I have a form set up as a continious form linking to a table.

One of the fields called post_added is a boolean field, if this value is false i want a button to appear next to that record which says “Add Transaction” .

have been playing around with the on current event but this brings up the button several times and i have to click on a record to change whether the button is visible or not.

any suggestions on how to go about this pleasE ?

Reply | Quote

Replies

I’m afraid that what you want is not possible. A continuous form actually contains only one set of controls. If you make a command button visible, it will be visible in all records, and if you make it invisible, it will be invisible in all records. The same would hold if you tried to enable/disable the command button, or to change the caption of the command button.

You could leave the button visible, check in the On Click event handler whether the Yes/No field is False, and get out if it isn’t.

Reply | Quote

had a feeling that would be the reply,

Reply | Quote

had a feeling that would be the reply,

Reply | Quote

I’m afraid that what you want is not possible. A continuous form actually contains only one set of controls. If you make a command button visible, it will be visible in all records, and if you make it invisible, it will be invisible in all records. The same would hold if you tried to enable/disable the command button, or to change the caption of the command button.

You could leave the button visible, check in the On Click event handler whether the Yes/No field is False, and get out if it isn’t.

Reply | Quote