hide blank / new record in continuous forms

  • Thread starter Rod Isaacs, St George Hospital
  • Start date
R

Rod Isaacs, St George Hospital

Hi all,
can anyone tell me how to elegantly hide the blank/new record in continuous
forms for easily confused users. Obviously there needs to be a way to show a
new record when required. I have tried putting a button on each continuous
form that toggles allowadditions to true (form design time default is Allow
Additions = No) but then there is no way to add the first record!
Thanks in advance.
 
D

Dan Artuso

Hi,
You could put this code in the form's open event:

If Me.RecordsetClone.RecordCount = 0 Then
Me.AllowAdditions = True
End If
 

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

DLookup in Continuous form 0
Blank continuous form 1
Hide textbox on a record - Continuous form 3
Cannot Add new record, then disable AllowAdditions 3
Displaying Records In A Continuous Form 3
Continuous Forms - Can it be done? 1
Continuous Forms View Question 2
Adding new record to a form 1

Top