Form help please

[golfinray]

I have a very large, busy form. I made a small form from the same query that
gives the details most often needed from that form. If they need to see all
the details of the record, they push a command button that takes them to the
large detailed from. How could I have the record they are looking at in the
small form open that same record in the large form? Thanks a bunch!!!

 

[Al Campagna]

golfinray,
Use the Where argument in your OpenForm method.
The lookup value should be your unique key field value (ex. CustID)

Use your own object names...
DoCmd.OpenForm "XYZ",,, "CustID = " & Me.CustID
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[golfinray]

Worked like a charm, Al, thanks!!

golfinray,
Use the Where argument in your OpenForm method.
The lookup value should be your unique key field value (ex. CustID)

Use your own object names...
DoCmd.OpenForm "XYZ",,, "CustID = " & Me.CustID
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Peter]

Thanks for this conversation i have the same issue...my unique key is part of
a "many" ralation...i used the below code but received "syntax error"..once
again..thanks for all idea and sollutions!

 

[Al Campagna]

Peter,
I'm not sure I understand.
Are you all set, or are you still getting a "syntax" error?
If so, cut and paste your code exactly as you have it, and describe the
field you're using in the Where argument (Num? Text?)
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."