Load Record from report in form

[rdirosato]

I'm an access newbie.

Platform: Access 2007

Question:
I have a report that lists information from my db.
I want to put an edit button at the end of each line item that when clicked will open a form called Help_Desk_Tickets with the proper record opened.
I want to do this with a macro.

I can get the button to load the form but cant figure out how to pass the right variable within the marco to display the correct record.

ID.........Name..................Issue............ ............Edit Button
01.........Mike Patton..........Needs New Mouse......[EDIT]
02.........Tori Amos............Needs Speakers.........[EDIT]


03.........Layne Stayley.......Accouunt Locked.......[EDIT]

When [Edit] button is clicked from report I want it to load Help_Desk_Tickets form with proper record selected via MACRO

Any help would be gratly appreciated.....

[pbaldy]

Sounds like you want this:

BaldyWeb wherecondition

If you want to stay with macros, you should see a where condition argument.

[rdirosato]

Thanks I looked at that and it seems abit over my head....

ACTION:
OpenForm

ARGUMENTS:
Form Name: Ticket_Input_Form
View: Form
Where Condition: [Forms]![Ticket_Input_Form]![ID]
Data Mode: Edit
Window Mode: Normal

[pbaldy]

While in that where condition row, hit F1 for context sensitive help. You need to specify the field name.

[rdirosato]

Is there an easier way to do this other than a macro?

[pbaldy]

"Easier" is in the eyes of the beholder, but personally I always use VBA code, never macros. The one line of code from the link would be all you needed. If you haven't used code before, here's a primer:

http://www.baldyweb.com/FirstVBA.htm

By the way, there is no need to send a PM as well as ask on the thread. I get emails of responses to the thread, so I will always respond on the thread.

[rdirosato]

I know how to add an even procedure could you provide me the code to pull off the proper record....

[pbaldy]

The link I gave in post 2 gives you the code; all you have to do is pick the appropriate one for the data type of your field, and change the various names to your own.

[rdirosato]

OK Lets just assume I'm an idiot.... Which I feel like now.... ;(

In advance thanks again for all your help.....

Table Name: Help_Desk_Main
Form Name: Ticket_Input_Form
Report Name: Open_Tickets

So when i launch the report it brings up rows of results when I click an icon at the end of that report I want it to load the form Ticket_Input_Form with the current record selected.......

Now say on a button I use an event procedure....

What do I need to put in between the below

Private Sub Command13_Click()

End Sub

Sorry if I'm annoying you... I am a noob to access

[pbaldy]

Well, you haven't mentioned the data type of the field, so I'll assume numeric. See if this works:

DoCmd.OpenForm "Ticket_Input_Form", , , "ID = " & Me.ID

[rdirosato]

Thank you so very much....

Worked like a champ.......

And yes it was a number..... auto number primary key to be exact...

Dude thanks again

Private Sub Command132_Click()
DoCmd.OpenForm "Ticket_Input_Form", , , "ID = " & Me.ID
End Sub

pbaldy is the man

[pbaldy]

LOL! No problem, and welcome to the site by the way.

[rdirosato]

If the form isn't open the above code won't work.
I tried this below and it seems to work if the form is opened or closed

Private Sub Command132_Click()
DoCmd.OpenForm "Ticket_Input_Form"
DoCmd.OpenForm "Ticket_Input_Form", , , "ID = " & Me.ID
End Sub

Thanks to baldy

[pbaldy]

Huh? I use that code all the time, and always on forms that aren't open. Can you post the db?