onclick open the same form/query (1 Viewer)

Y

YouMust

Registered User.

Local time

Today, 15:28

Joined

May 4, 2016

Messages

106

• Nov 12, 2019

• #1

hello again..

I have a form linked to a query.

when the form opens its asks for a part number

it takes the part number and populates the form with a bill of material (a list of parts).

What I'd like is when a part number is clicked on from the list that part number is then passed back to the form/query. that way people can drill down through parts lists without having to manually type in a new part number.


I've gotten the control but im unsure how i pass this back to the form again?
[Forms]![frmBomViewer]![PART]

 

theDBguy

I’m here to help

Staff member

Local time

Today, 15:28

Joined

Oct 29, 2018

Messages

21,453

• Nov 12, 2019

• #2

Hi. My suggestion would be change the query to refer to a form control rather than prompt the user for a parameter. When the user clicks on a part number, you can copy that part number into the form control that the query is using and then requery the form.

 

Y

YouMust

Registered User.

Local time

Today, 15:28

Joined

May 4, 2016

Messages

106

• Nov 13, 2019

• #3

thanks so much theDBguy

I've made an input box.

My query is now:

Code:Copy to clipboard

Like "*" & [Forms]![frmBomViewer]![Searchbox] & "*"

and in the unbound box I put an after update event

Code:Copy to clipboard

Private Sub SearchBox_AfterUpdate()

frmBomViewer.Requery

End Sub

but cant seem to requery

 

theDBguy

I’m here to help

Staff member

Local time

Today, 15:28

Joined

Oct 29, 2018

Messages

21,453

• Nov 13, 2019

• #4

How about?

Code:Copy to clipboard

Me.Requery

 

Y

YouMust

Registered User.

Local time

Today, 15:28

Joined

May 4, 2016

Messages

106

• Nov 13, 2019

• #5

Perfect!!

do you wear a cape!!?

 

theDBguy

I’m here to help

Staff member

Local time

Today, 15:28

Joined

Oct 29, 2018

Messages

21,453

• Nov 13, 2019

• #6

YouMust said:

Perfect!!

do you wear a cape!!?

Click to expand...

No comment...

 

Y

YouMust

Registered User.

Local time

Today, 15:28

Joined

May 4, 2016

Messages

106

• Nov 14, 2019

• #7

Is there away to make this update on the fly rather than if i tab out.

Most users will be using touch screen. i could put a button in I guess but it'll be nice if it just updated as it was typed.

Edit:
This would be nice, but i have added a search button and its all working. so no drama

 

Last edited: Nov 14, 2019