Opening a specific record on another form... 1

[Stargrove]

I have a form that I will call Workorder. I have another form that I will call ProjectOutline. Each is based on two separate tables with the unique WO# being the common link between the two tables.
I have a button on the Workorder form, that when clicked, should open the ProjectOutline form to it's corresponding record so the information there can be edited.
I am currently using the OpenForm command, go to control command (I think thats right) and FindRecord command. I have this same thing working when going from the ProjectOutline form to the work order, but cannot get the same process to work going the other way.
I know that the way I am curently doing this is probably not the best way and hopefully someone can give me a snippet of code that will always finction correctly.

I know this should be easy, but I can't seem to get it to work...

James

 

[ajdesalvo]

Try this:

DoCmd.OpenForm "ProjectOutline", , , "[WO#] = '" & Me![WO#] & "'"


Godd luck! Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"

 

[sebell]

ajdesalvo,
Thank you so much -- this was very helpful for me as I had the same problem and saw this posting. Thank you Thank you!!!!!