data entry form

  • Thread starter Thread starter doob
  • Start date Start date
D

doob

when i open a data entry form how do i make it open with a new line ...
so that i dont need to go to the end of the current data

also, the current data is too easily changed in the form, is it straight
forward (total beginner here) to make current data read only until an
amend or edit button is clicked?
 
Open To New Line ----

Open your form in design view. Go to properties and the Data tab. Set Data Entry
to Yes.

Make Current Data read only until an amend or edit button is clicked -----

Open your form in design view. Go to properties and the Data tab. Set Allow
Edits to No. Then put the following code in the OnClick event of your Edit
button:
Me.AllowEdits = True

Then put the following code in the OnCurrent event of the form:
Me.AllowEdits = False
 
Open To New Line ----

Open your form in design view. Go to properties and the Data tab. Set Data Entry
to Yes.

Make Current Data read only until an amend or edit button is clicked -----

Open your form in design view. Go to properties and the Data tab. Set Allow
Edits to No. Then put the following code in the OnClick event of your Edit
button:
Me.AllowEdits = True

Then put the following code in the OnCurrent event of the form:
Me.AllowEdits = False
Click to expand...

thanks for that, all followed but cant seem to find the OnCurrent event
of the form you mention at the end .. its access 2000 im using - am i
just being short sighted? ;)
 
Open the form in design view. You should see "Form" in the object box at the far
left of the toolbar at the top. Open properties and go to the Events tab.
OnCurrent should be at the top of the list. It's an event property of the form.

Steve
PC Datasheet
 
I saw this message and went to use the tip in the
database I am currently building. I copied and pasted the
command lines at the appropriate places. But when I open
the form, I get the message "Microsoft Access can't find
the macro "Me."

Any idea of what I did wrong? Thanks for your help!

-----Original Message-----
Open the form in design view. You should see "Form" in the object box at the far
left of the toolbar at the top. Open properties and go to the Events tab.
OnCurrent should be at the top of the list. It's an event property of the form.

Steve
PC Datasheet


Click to expand...
 
I saw this message and went to use the tip in the
database I am currently building. I copied and pasted the
command lines at the appropriate places. But when I open
the form, I get the message "Microsoft Access can't find
the macro "Me."

Any idea of what I did wrong? Thanks for your help!
Click to expand...

i had this too but so far too many things i dont understand about access
to have a clue ;)
 
Back
Top