add a link from a simplified list form to the detailed form

[rmulder]

Alright, I have "orders" that have been queried and turned into a form with limited fields in a list for nice viewing and editing. Let's call that form "local dispatch" i also have a form that shows all the orders, one per page, with all the fields for the order. Let's call that form "inbound orders" I would like to create a link next to each order in the "local dispatch" form that either queries or searches the "inbound orders" form for that order and displays it so that the user has quick access to ALL details on that order. I don't have a real great idea on where to start. The "inbound orders" has been created from the standard "Form" template. "local dispatch" has been created using the "Multiple Items" Form template. Thanks everyone!!!

 

[rmulder]

kinda treading down road of a query, then making a copy of "inbound orders" form and change it's record source to the query. right track??? prob not lol

 

[rmulder]

this is very similar to what I'd like to do
http://bytes.com/topic/access/answers/642457-open-form-specific-record
i've been trying this in the macro builder but it keep asking me for the value of Me.[PO#] in my case. not sure how it'd know which PO# I'm referring to when it's a list of many orders with many po#s but i think this is getting me on the right track.

 

[rmulder]

alright, i skipped from macro builder to code builder and the click event of the button i have.... using the resource cited above i came up with.....
DoCmd.OpenForm "frm_Inbound", , , "[PO#]=" & Me.[PO#]

When I click it, it switches to the Inbound form but the VBA throws run-time error '3464' - Data type mismatch in criteria expression. Any ideas on this as in the data tab, both fields on both forms are type text???