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

[Linda1503]

Remove the ProductID and the full stop and reenter the full stop.
Not even sure how you switch intellisense off TBH, nor why

Here are my Options
View attachment 95173

That works duh! Thanks but the only options it gives are the name of the button the code is in and ActiveControl, AfterDelConfirm etc - would send a screen shot but it disappears on nip!
The pop up form is Product Search, the sub form datasheet I'm selecting from is named Child1, any idea how I would refer to a selection in that?

 

[Linda1503]

Probably not switched off, but if the code will not comply because there are other errors somewhere it will stop working.
Hit Debug > Compile to fix all errors first.

Hi, the database compiles fine apart from this wee bit of code - not switched off - I'm just not switched on in how to use it

 

[mike60smart]

Can you upload the database?

 

[Linda1503]

That works duh! Thanks but the only options it gives are the name of the button the code is in and ActiveControl, AfterDelConfirm etc - would send a screen shot but it disappears on nip!
The pop up form is Product Search, the sub form datasheet I'm selecting from is named Child1, any idea how I would refer to a selection in that?

Can you upload the data

Can you upload the database?

Sorry had to delete the customer details - even so the file size is too large to upload...

 

[mike60smart]

Sorry had to delete the customer details - even so the file size is too large to upload...

Hi
I just sent a conversation message.

 

[Gasman]

That works duh! Thanks but the only options it gives are the name of the button the code is in and ActiveControl, AfterDelConfirm etc - would send a screen shot but it disappears on nip!
The pop up form is Product Search, the sub form datasheet I'm selecting from is named Child1, any idea how I would refer to a selection in that?

Well that would be Me.SubformControl.Form.ControlName ?
Adjust names accordingly.

 

[Linda1503]

Probably not switched off, but if the code will not comply because there are other errors somewhere it will stop working.
Hit Debug > Compile to fix all errors first.

Sorry should have replied to this all code compiles fine untill this line of code is added...

 

[Linda1503]

Well that would be Me.SubformControl.Form.ControlName ?
Adjust names accordingly.

I'm still doing something wrong - If you have a main form (which is not involved at this point), a subform & a sub sub form (which is in datasheet view & which has an unbound combo box filtering it) how would you get the current record selected in the sub sub form datasheet to the sub form in vba code in on click of a button?
Or will I just tell them to remember the filter code and input it again - I do hate to woose out :-/

 

[Linda1503]

I'm still doing something wrong - If you have a main form (which is not involved at this point), a subform & a sub sub form (which is in datasheet view & which has an unbound combo box filtering it) how would you get the current record selected in the sub sub form datasheet to the sub form in vba code in on click of a button?
Or will I just tell them to remember the filter code and input it again - I do hate to woose out :-/

 

[Linda1503]

I'm still doing something wrong - If you have a main form (which is not involved at this point), a subform & a sub sub form (which is in datasheet view & which has an unbound combo box filtering it) how would you get the current record selected in the sub sub form datasheet to the sub form in vba code in on click of a button?
Or will I just tell them to remember the filter code and input it again - I do hate to woose out :-/

Not convince that's how you spell woose , whoose, wouse?

 

[Gasman]

Think of the hierarchy of the forms.
Try using the Builder in the Query GUI to get the correct syntax, copy and paste that.

 

[Gasman]

View attachment 95177

I did say 'change the names to suit'
I have no idea what your controls are called, only you know that.?

 

[Linda1503]

Think of the hierarchy of the forms.
Try using the Builder in the Query GUI to get the correct syntax, copy and paste that.

No idea what or where the Query GUI is - giving up for now ... got to pull user instructions together - they'll just have to put up with my inadequacies

 

[Gasman]

No idea what or where the Query GUI is - giving up for now ... got to pull user instructions together - they'll just have to put up with my inadequacies

When you create a query in design mode, that is the GUI.
In that screen is the Builder that allows you to select a control via a treeview like control.

 

[Linda1503]

Thanks Gasman

 

[Gasman]

Keep this link handy

Forms: Refer to Form and Subform properties and controls

 

[Linda1503]

Hey! Thank you

 

[Gasman]

Hi Linda1503,
I cannot see that you have uploaded your DB, but I saw a PM post from mike60smart, so assume you gave him your DB by some other method, other than loading up here?
I thought you (and others here) should be aware that he is now asking for help on how to fix your problem over on UA, where he asks most, if not all of his questions on VBA.
https://www.utteraccess.com/topics/2062029/posts/2788019

So if it comes back as fixed, you can be certain it was not Mike doing the work, but someone else.

In fact he is crossposting on your behalf.

 

[Linda1503]

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

 

[Linda1503]

Hi Linda1503,
I cannot see that you have uploaded your DB, but I saw a PM post from mike60smart, so assume you gave him your DB by some other method, other than loading up here?
I thought you (and others here) should be aware that he is now asking for help on how to fix your problem over on UA, where he asks most of his questions on VBA.
https://www.utteraccess.com/topics/2062029/posts/2788019

So if it comes back as fixed, you can be certain it was not Mike doing the work, but someone else.

In fact he is crossposting on your behalf.

I know this is a bit of a sad question but ... how do you get all the emojis? I can only do a smiley face which gags me!!!