onclick open the same form/query

[YouMust]

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]

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.

 

[YouMust]

thanks so much theDBguy

I've made an input box.

My query is now:

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

and in the unbound box I put an after update event

Private Sub SearchBox_AfterUpdate()

frmBomViewer.Requery

End Sub

but cant seem to requery

 

[theDBguy]

How about?

Me.Requery

 

[YouMust]

Perfect!!

do you wear a cape!!?

 

[theDBguy]

Perfect!!

do you wear a cape!!?

No comment...

 

[YouMust]

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