Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

edit the records defined in a form

edit the records defined in a form

edit the records defined in a form

I have a database with multiple entries. (i.e., one cages, deeler, adress, etc) I have used forms & subforms liberally and lots of tables throughout my database with command buttons and all of that good stuff. I would like the values I enter in on a "general Information" form to be modifiyed (i.e. I would only like to enter the information once.)

How can i change the field list for this form, i need to delete one record defined in this form because i do not need that info anymore and when i try to set a new record and error appear (it ask me to fill the record i already deleted). Well, after that i decided to do a new form, but now my problem is that i need to add another field to my form and i don`t have it in the field list of my new form.

I also tried to set this new record with the expression generator utilitie but i get an erro "name" every time i run this form.

 I have tried to copy information to forms/subforms, write update queries, and a couple of other things to make this work. I suspect it is something simple, i just need somone to get me over the top on this one.



RE: edit the records defined in a form

I assume that you have text boxes on your form.  Have you tried to set the default property to your text boxes and have that store your information that you want to modify?  If you want to delete a specific record that is viewing on your form then try having a command button and a delete query on the click event of the command button.  Please let me know if you need example code for the delete query.

RE: edit the records defined in a form


Well actually i`m not using any query in this form, it`s just a form with fields (combo boxes, text boxes, subforms)taken by a table, my question is focus in if there is any way in witch i can add another field to my form that i don`t have it in the courrent field list (the ones that were defined whe i create my form), or i will always need to do a new form if i want to modify my form or data design.

thanks for answer me....
keep in touch please.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close