Passing avalue from one form to another

  • Thread starter Thread starter Angel G
  • Start date Start date
A

Angel G

I have a form (ItemBrowse_frm) that provides me a list of active Item
numbers. When I click the Item number I want to pass the Item number to my
other form (SingleBill_frm) and requery the form based on that part number.
I am using the following OnClick
Forms![SingleBill_frm]![ParentItembx].Value =
Forms!ItemBrowse_frm.[ItemNumber]
Forms![SingleBill_frm].Requery
Somehow the SingleBill_frm does not requery and the field that I am passing
the value to does not show the value passed until I highlight the field. Is
there a better way to do this or what am I doing wrong?
Thank you!
 
Try creating a variable to hold the value you want to pass.

Public x As String (or whatever type you need)

OnClick
Me.ItemToPass = x

On the new form, set a filter to x.

That is a really high level explaination. If you need more, reply.
 
Back
Top