How do I save data in listview in table

[biancaioana]

I have a form that I want to put a code into the Save button to save the data in the table named in the listview tblAdres. Attach the model.Thanks to those who can help with a demo.

 

[G37Sam]

I've never worked with Treeviews/Listviews but here's some help on them: http://www.databasejournal.com/feat...p/3734331/Access-TreeView-ListView-Basics.htm

I'd avoid working with ActiveX controls overall to avoid reference issues at distribution. What you're trying to do can be easily done via a subform.

 

[biancaioana]

What you're trying to do can be easily done via a subform.It may be a demo?

 

[biancaioana]

I solved.I want to make a code value to look for in the listview (lvwDepartments - setfocus) you can change the value.Does anyone know?

 

[vbaInet]

I don't understand your last post. What is your query?

 

[biancaioana]

I do not know this.

 

[vbaInet]

I'm asking, what is the problem you're trying to solve?

 

[biancaioana]

The forms I have a button that I want to look for a value after the data in the table.

 

[vbaInet]

Alright, I've opened your db and I still don't follow. If you want to save data in a table, you need to use a form. You can also embed a subform in a form and base that subform on your table.

 

[biancaioana]

You have a demo.Thanks a lot.

 

[vbaInet]

Demo of what? A subform?

Are you the author of the demo you attached?

 

[biancaioana]

Yes.Demo of subform.

 

[vbaInet]

I don't have a demo of a subform unfortunately. There's lots of information about this on the net:

http://office.microsoft.com/en-us/access-help/create-a-subform-HP005187803.aspx
http://www.techonthenet.com/access/subforms/

You can also use an UPDATE query to save information to a table.

 

[biancaioana]

Thanks for your support.

 

[vbaInet]

No problem. Let us know if you need more help.