USerform First Record& last record in the form for Updation

[Parth007]

I have a userform in Access.. which is used by user to input the data..
After clicking save button the records gets stored in the Access Table "Main" ..


Can we use the First record, Next record, second last record & last record bar in the userform..
so that If user want to update any of his data saved wrogly can be rectified?

I have a Update button too in userform

[Norie]

Can't you just use Access?

Forms in Access have all that functionality built-in, in Excel you would need to code it all.

[Parth007]

Trying to use it in Access only.. But i am not able to populate the records back from Access table to Access userform

[Parth007]

Trying to use it in Access only.. But i am not able to populate the records back from Access table to Access userform

[Norie]

That should be straightforward, what are you using as the record source for the form?

[Parth007]

In Form Properties i am using Table name as Record Source...

[Norie]

Then you should be able to navigate through all the records using the standard controls on the form.

Unless you've set the form up for data entry only.

[Parth007]

Thats confusing... I did google & somehow made the form

Form looks like this

User Opens the user form..

User form have 5 Combo Box & 5 text box..
Now user select combo values which i have inoputted in combo box properties (Row Source)
& then user fills data in 5 text boxes..

Now user press save button

The record gets stored in table.

Its working fine till here.


Now query is Table dont have duplicate data.. acceptable..
How do the user update the data wrongly enetered.. any way put
How to back track if user accidently saved wrong data..


any idea will do..

its just the user should be able to update the data .. any method will do

[Norie]

Any chance you could upload a sample file?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

[Parth007]

I would have done it but no ways to do coz of some restrictions..
but Norie thanks for it..
I somehow figured out to create a New Form for updation of records.. i am doing well step by step.. hopefully will complete it soon

lets see where i get stuck in it

[Norie]

Are you using Access?

If you are try posting in the forum's Access section.

[Parth007]

Yes will surely do that