Getting selected record from "Search Part" pop up form to main form

[Gasman]

See the smiley icon, two to the right of the link icon in the toolbar for your post.

 

[Gasman]

Hey I think it's his hobby - no hassle - Thank you for the naming conventions & hints n tips - working on it now (arghhh!)
I'll let you know if I get there

Let's see if you can get there before Mike

 

[Linda1503]

I am so at this thanks for all the help

 

[Gasman]

Yes, naming conventions might be lacking, but that is not going to solve her issue?
However, just like crossposting, advising of the true nature of the query, is a matter of common courtesy, and certainly for anyone on UA wishing to help, linda's posts are a lot clearer here as to the problem, than yours on UA?

DB is too recent for me to open, so I can only help out in theory.

 

[Linda1503]

Okay, got the thing to work but have 1 (hopefully) SMALL problem...
I need to use VBA on click of a button to do it - But I had been using that button to close the form via a macro.
I hate to admit this but I have NEVER (despite trying) managed to close a form using VBA.
So the button is on the form I want to close...
The name of the form is "ProdSrchFRM"...
The code I have fails on the DoCmd.Close - what on earth am I doing wrongggggg
Also not sure where that line should be to allow the Else bit to do it's bit...
Please help
Ps. Mike60smart - not great to post my DB without asking...

 

[Linda1503]

Pps. The code works fine without the DoCmd bit...

 

[mike60smart]

Pps. The code works fine without the DoCmd bit...

Linda My apologies I wrongly assumed that because you had removed the confidential data it would be OK.

 

[Linda1503]

Linda My apologies I wrongly assumed that because you had removed the confidential data it would be OK.

Please delete it

 

[mike60smart]

OK Done

 

[isladogs]

OK Done

However the file is still there at UA. Better remove that as well!

 

[Linda1503]

However the file is still there at UA. Better remove that as well!

Can anyone help on how to close the form?

 

[isladogs]

Add a close button and add code to its click event: DoCmd.Close.
Or if that doesn't work for some reason, use DoCmd.Close acForm, Me.Name

 

[Linda1503]

Add a close button and add code to its click event: DoCmd.Close.
Or if that doesn't work for some reason, use DoCmd.Close acForm, Me.Name

From post above:
So the button is on the form I want to close...
The name of the form is "ProdSrchFRM"...
The code I have fails on the DoCmd.Close - what on earth am I doing wrongggggg
Also not sure where that line should be to allow the Else bit to do it's bit...

 

[isladogs]

You don't refer to the current form by using its actual name there.
Type in EXACTLY what I wrote before!

BTW you don't need the acSaveYes part unless you have changed the form DESIGN. New/edited records are saved automatically.

 

[Gasman]

You would use Me.Name in that case