Updating records in access
Forms: Forms in MS Access are the basically used for displaying the item for which you are looking.As forms are objects through which user can easily add, edit or display the data stored in access database.When I change the company name, it does not change in the table.I’m not sure why it isn’t updating, can anyone help me?I'm more or less looking for a resource (or keywords to search) so I can figure this out on my own Thank you!UPDATE: Once I hit okay on the frm Proj Msg Box it fills out text boxes that have controls on frm Project to create the parent record (i think that's the term) in tbl Project. I would like access to go out to the tbl Milestones_Inf and match the project type (child record? It would then add 4-5 records based on matching Project Type on the Milestone_Inf table.I have a form that displays each of these jobs one-by-one, and has two buttons (Job has been completed, and Job not completed). I cannot find a way to get access to the current record to update it's contents if the "Has been Completed" button is pressed, the closest I can get is the long number which represents the records position in the form. This is called on button-press I am posting an image which shows the form (non-continuous).The VBA to get the index of the record in the form is as follows. Execute str SQL1, db Fail On Error str SQL2 = "UPDATE job SET JOB_NEXT_OCCURANCE = JOB_NEXT_OCCURANCE JOB_RECURRANCE_RATE WHERE job. @Hans Up, I get what you are saying, but I dont quite think it's applicable (I did not provide enough information first time around for you to understand I think) @sarh I believe this Recordset that you are talking about is what I need, however I cannot figure out how to use it, any hints?
I'm sure there's a simple solution but I need help being pointed in the right direction.So you can write something like this (not the best example, but can help you to get an idea): Consider a simpler approach.I doubt you need to be concerned with the form's Current Record property.So, the design of your form is an important aspect.
You can do a lot more things with designing of the form in MS Access.
Basically there are two basic types of forms: If you are a newbie Access user or not very familiar with the concept behind relational database.