Possible to click a button in a list to edit that record?

[Michael]

I am used to working in asp and do not know how to do this in access.

I would like to have a list of records with a button at the end of the list
or just click on that line and go to another form that is already filled in
from the referring page.

thank you
Michael

 

[Brendan Reynolds]

You pass the value of the primary key field(s) of the current record in the
WhereCondition argument of the OpenForm method ...

Private Sub Command10_Click()

DoCmd.OpenForm "MyOtherForm", , , "EmployeeID = " & Me.EmployeeID

End Sub

Here's a link to the on-line help topic on the OpenForm method ...

http://msdn.microsoft.com/library/en-us/vbaac11/html/acmthactOpenForm_HV05186497.asp

 

[Michael]

Thank you Brendan,
I guess I did not explain myself well enough.. I want to generate a list in
a form from a query and open the table in data view or something so I have a
list of orders.
then I want to click on one of the records and pass that primary field to
the next page as you suggested, how can I add a button to the end of the
line or make the line as an active hyperlink? In asp I would do it like this
"getRep.asp?rep_id=<%=(Recordset1.Fields.Item("rep_id").Value)%>" after
creating a repeat region to add all the orders.

michael

 

[Brendan Reynolds]

It's easier to show you what I'm talking about than to try to explain it.
Take a look at the form "frmMain" in this demo ...

http://brenreyn.brinkster.net/db16.zip

 

[Michael]

Thank you very much Brendan for taking the time to put that together. I will
not try to make sense out of it. I think it is pretty straight forward, just
me getting it built correctly. This sample will make it allot easier.
michael