Mutli record button on form.

[Mounds]

I'll try and paint as clear a picture as I can for who may be able to help on this one. I have a form setup in a tabular style. The form draws orders from a query that fall into certain parameters. The order numbers get listed down a left hand column. I have placed a command button called "GotoOrder" that I would like for the user to be able to click and it sends the user to another form for the selected order. I don't know how to make it so the button I push selects the corresponding order since they are all coming from the Order table. I'm not sure if this is making sense. I'd love some help if I could get some. It's been driving me in circles for a couple days now. I'll try adn load some screen shots if I can.

[ajetrumpet]

what you want to do is get a pointer somewhere. for instance, a listbox with order ids in it would work fine. then, you open the form and write the listbox value into the filter code, e.g. - the WHERE clause argument in the docmd command. that's all there is to it. but you need a target to point to first. without that, there's no way to do it, obviously.

there is also no issue with opening a form twice with the same recordsource, just for viewing purposed. you can open as many as you want, as I have witnessed.

[Mounds]

Thanks a lot. The list box works, and I think I'll have to call that good enough. Cause as you said with out a pointer nothing will work.