Continuous form questions

  • Thread starter Thread starter Lampy
  • Start date Start date
L

Lampy

Hi

On a continuous form, i have discovered how to enable/disable field
by checking/unchecking a box, but is there a way o
enabling/disabling the fields for only the relevant record and no
for all records

Also in a continuous form, i would like no further record addition
after the first record until a button is clicked on. Is thi
possible

Any help is greatly appreciated

Cheers

Lamp
 
Lampy,

You can enable/disable tetxboxes on a continuous form by Conditional
Formatting... select the textbox in the form's design view, and then
look under the Format menu.

You can set the AllowAdditions property of the form to No on a suitable
event of the form... I have done it by using the After Update event of
the first data control on the form, to save the record first, like this...
DoCmd.RunCommand acCmdSaveRecord
Me.AllowAdditions = False
.... And then use VBA code on the button's Click event like this...
Me.AllowAdditions = True
 
Back
Top