User Input Form

[dragonfly]

I am trying to make user input forms for each of the tables in my current database. I have made the forms, but I am required to have the forms come up blank first (so they can create a new record), but allow the user to edit existing records too. How do I do this?

 

[AWilderbeast]

create a two forms one named 'frmaddwhatever' one named 'frmeditwhatever', then click the properties of the add form go to data and change data entry to 'yes'. then use a swtichboard to open the two diff forms

 

[MarkK]

Consider using a toggle button to change the DataEntry property of the form. If you have a toggle named "togDataMode" then...

Private Sub togDataMode_Click()
   Me.DataEntry = Me.togDataMode
End Sub

 

[dragonfly]

create a two forms one named 'frmaddwhatever' one named 'frmeditwhatever', then click the properties of the add form go to data and change data entry to 'yes'. then use a swtichboard to open the two diff forms

Normally I would do that, but this is part of an assignment for uni and the specification states that was have to do it on the same form... "when the form is openned it should go to a blank form, but also allow the user to edit existing records". :S

Any ideas?