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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form real refresh 2
Continuous Forms View Question 2
Blank continuous form 1
Continuous Form: Change the color of one row 1
Odd Cursor Behaviour 22
Continuous Forms 1
conditional printing/display in a continuous form 0
Total only specific records on a continuous form 2

Back
Top