Edit data in table

[habbabub]

hi, im amaturish at access, but im wondering what would be the easiest way to create a edit page, via any means. eg. in a form?

cheers

 

[Uncle Gizmo]

Just click on the table you want to edit, so that the table name is highlighted, then select the form wizard from the menu at the top and this will produce a basic form that you can use to edit entries in the table.

 

[habbabub]

thats unexpectidly easy!, but how do i create a text box or message box that ask for a specifc name, and then just display the details of that to be edited, so i dont have to keep on clicking the right arrow to get to the one i want to edit?

 

[Mike375]

You need to buy a book on Access, even it is a very small book

Or go to Access Help and search on filter or filtering or similar and combo

A simple combo will do what you want

 

[habbabub]

is there any way u can explain the steps to insert the combo box and make it correspond in a way that all the info is dump into the feilds which then can be edited? and then a button to save the information?

 

[Mike375]

Too long and hard when you have no knowledge.

Just go to your form in design view, select the toolbox and wave the mouse over the little icons and one will show combo. Click it and then click on the part of the form where you want it to be and follow the instructions. Basically, a combo box will insert data into a field or find a record and it is the latter you want. You make the choice while going through the instructions

 

[Uncle Gizmo]

>>>how do i create a text box or message box that ask for a specifc name, and then just display the details of that to be edited<<<

There is a set of six videos here which explain what you want I believe.