Code : DoCmd.OpenQuery - and bring result back to form front

[Tyson]

I have got this little piece of code that fires on exit of a text box.
It run's my query perfectly based of my form input. But I don't know
how to bring result in my query back to a text box on my form, and
shut down query so I can keep using my form again. Thoughts?

I am getting a little freaked, I am sure this must be easy?

form is; frm_RR_datacapture
query is;qprGB_Piece_SizefromTextBox
textbox is;RR_Adjusted_GB_Piece_Size_Production_Adjustment
Private Sub RR_Adjusted_GB_Piece_Size_Production_Adjustment_ex it(Cancel
As Integer)
DoCmd.OpenQuery "qprGB_Piece_SizefromTextBox"

End Sub

Cheers

[Pieter Linden]

ty**********@hotmail.com (Tyson) wrote in message news:<7f*************************@posting.google.c om>...

I have got this little piece of code that fires on exit of a text box.
It run's my query perfectly based of my form input. But I don't know
how to bring result in my query back to a text box on my form, and
shut down query so I can keep using my form again. Thoughts?

I am getting a little freaked, I am sure this must be easy?

form is; frm_RR_datacapture
query is;qprGB_Piece_SizefromTextBox
textbox is;RR_Adjusted_GB_Piece_Size_Production_Adjustment
Private Sub RR_Adjusted_GB_Piece_Size_Production_Adjustment_ex it(Cancel
As Integer)
DoCmd.OpenQuery "qprGB_Piece_SizefromTextBox"

End Sub

Cheers

Hmm... one way is to create an unbound subform and assign the
recordsource to the query and then bind the subform the the query at
runtime...

[Tyson]

pi********@hotmail.com (Pieter Linden) wrote in message news:<bf**************************@posting.google. com>...

ty**********@hotmail.com (Tyson) wrote in message news:<7f*************************@posting.google.c om>...

I have got this little piece of code that fires on exit of a text box.
It run's my query perfectly based of my form input. But I don't know
how to bring result in my query back to a text box on my form, and
shut down query so I can keep using my form again. Thoughts?

I am getting a little freaked, I am sure this must be easy?

form is; frm_RR_datacapture
query is;qprGB_Piece_SizefromTextBox
textbox is;RR_Adjusted_GB_Piece_Size_Production_Adjustment
Private Sub RR_Adjusted_GB_Piece_Size_Production_Adjustment_ex it(Cancel
As Integer)
DoCmd.OpenQuery "qprGB_Piece_SizefromTextBox"

End Sub

Cheers

Hmm... one way is to create an unbound subform and assign the
recordsource to the query and then bind the subform the the query at
runtime...

Hi, Thanks...

Is there anyway I can do it without a subform so it is all run from
the one main form?

Option 1; I was thinking i would like to add a little code after the
Open.query statement above to bring it back to a text box?

Option 2; The other thought I had was a Dlookup but have tried that
and it doesn't seem to work? could it be a text thing?

I like option 1, but do not have the skill base to write code to do
this? Would you be able to help?

Sorry about the length of the names here!!!!

form is; frm_RR_datacapture
table is; tbl_GB_Piece_Size
query is;qprGB_Piece_SizefromTextBox
textbox is;RR_Adjusted_GB_Piece_Size_Production_Adjustment
Lookup Column is Piece_Size
Column I am wanting a return value from is called :
Production_Adjustment

I hope this helps, I am really stuck...

Thanks
Tys.