Reputation: 2568
I have to create a ms access form which has a text box and a button. I want to retrieve multiple records from db and show all those rows in ms access Form on click of the button.is there a way to show multiple records on a ms access form something like a datagrid and once i retrieve those records I should be able to update them.Please let me know if there is a solution
Regards, Ravi
Upvotes: 2
Views: 23708
Reputation: 7215
It sounds like you are referring to a continuous form. Here are a few links on the subject.
http://www.blueclaw-db.com/access_continuous_form_subform.htm
http://www.mvps.org/access/forms/frm0024.htm
It is one of the main plus points of access and one which can be used to great affect. Failing that you can use the datagrid activeX control and populate it through code but that is a little more involved (still quite easy still)
Upvotes: 2