Edit previously saved Field in a Form

  • Thread starter Thread starter Palto Fondberg
  • Start date Start date
P

Palto Fondberg

Hi

I want to be able to edit some or all fields which have previously been
entered on a form.
Records have been previously entered and saved by being typed in and/or
selected on a form. When I select a particular CustomerID, I can view
particular saved records, and I want to introduce the option to amend
particular fields. I want to have an 'on click' event, whereby I can edit
these fields. Although I've looked at "allow edits" and such like, I'm
struggling with what exactly I should do, and what code to use/how to
structure it. Can someone help please?
 
Yes Jeff.

For others out there who are looking for help on this, I figured out what I
was doing wrong. You can't amend Form details if that particular Form is
based on a query which cannot be amended. [ie: as a quick check, run the
underlying query behind the form, and try and edit one of the fields - if
you can't do this, then you need to look into how you have created the
query - you may have to delete one or more tables within this query before
you have an "amendable" query - Once you have a query which allows you to
edit the result fields then you can use this to base your form on - hence
you will then be able to edit the fields.

I hope this makes sense - Jeff, am I right?


thanks
 
I couldn't have said it better myself.

Thanks for posting back what you found ... it will help others who are
looking for this answer.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Palto Fondberg said:
Yes Jeff.

For others out there who are looking for help on this, I figured out what I
was doing wrong. You can't amend Form details if that particular Form is
based on a query which cannot be amended. [ie: as a quick check, run the
underlying query behind the form, and try and edit one of the fields - if
you can't do this, then you need to look into how you have created the
query - you may have to delete one or more tables within this query before
you have an "amendable" query - Once you have a query which allows you to
edit the result fields then you can use this to base your form on - hence
you will then be able to edit the fields.

I hope this makes sense - Jeff, am I right?


thanks

Jeff Boyce said:
If you bind a form to a table you should be able to "edit" the fields
display via the form.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
Click to expand...
Click to expand...
 
Back
Top