Open form with blank fields

[fileman1]

After all the years of Access, do we still have to use Data Entry = Yes to get a blank form prior to finding a record? or has there been a solution in current version. (2010)

 

[PHV]

has there been a solution
A solution to which problem ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[missinglinq]

How were you planning on finding the Record after opening to a 'blank' Record? You can't use the usual Combobox with the 3rd Option, because when you open a Form with Data Entry set to Yes there are no Records in the Form's recordset. Only Records entered in that session are there to be retrieved!

We usually do this by moving to a New Record on opening the Form, with Data Entry set to No:

Private Sub Form_Load()
  DoCmd.GoToRecord , , acNewRec
End Sub

The Missinglinq

Richmond, Virginia

The Devil's in the Details!

 

[fileman1]

Thanks both. I will just disable all fields, and change the fore colors of each control to match background color white.

One of the reasons I just prefer unbound forms. I think when a form opens it is so confusing to the user to see all the fields already having data in. A thought, but am I allowed to remove and replace the record source of the form?

 

[MajP]

This is a fundamental design problem I see novices do, and I would rarely ever do it this way. Having a single view to add, edit, and navigate makes forms overly complicated IMO. I usually have separate view to navigate and possibly a separate view to edit. But the add form is almost always a separate view.