search and edit members

[Mohammadsharif]

I have registered members and groups in my access database and i want to create a search form that enable me find and edit registered members of groups.but i dont know how to do this please help me

[ranman256]

Make a form (tabbed multi record) with a box to enter the search name. Rename it txtName

make a query to do the find...it will be like:
select * from table where [name] like *" & forms!frmFind!txtName & "*"
Call it qsFind
In the AFTERUPDATE event of the txtName box, assign the qsFind to the form. Me.recordsource = "qsFind"

another button to EDIT on the selected record:
docmd.openform "frmEdit",,"[id]=" & me.ID

[Mohammadsharif]

thanks for reply i want to have some thing like this format ..what u sayed is too complicated

[ranman256]

Then you dont need the box, just put the cursor in the name box and press CTRL-F