Search results

Hi Galaxiom So Access looks for a control then a field.. I was told my JANR that the Me refers to the mainform where the subform(F_Order_line_subform) i am trying to access is contained. Therefore the code should be. Me(F_Order << Mainform).F_Order_line_subform(subform control for subform...

JANR I was unaware the Me actually referred to the main form so thankyou for that. Here is my new code. Code: Private Sub AddtoOrder_Click() On Error GoTo Err_AddtoOrder_Click Me!Product_Catalogue.Form.ProductID = Me!F_Order_line_subform.Form.ProductID Me!Product_Catalogue.Form.Category...

Hi JANR Thanks for your help :) I know this is what he meant but im still getting errors? Code: Private Sub AddtoOrder_Click() On Error GoTo Err_AddtoOrder_Click Me.F_Orders.Product_Catalogue.Form.ProductID = Me.F_Orders.F_Order_line_subform.Form.ProductID...

Galaxiom, I am already including the form name in my code. The form is F_Orders. I still dont understand why it isnt working. I have... Me.Form.SubForm.FieldName. Why isnt this working!? Thanks for being patient and helping!

Thanks again GlaxiomAtHome! I have tried to do what youve said, i think i understand now but for some reason i am still getting errors. Private Sub AddtoOrder_Click() On Error GoTo Err_AddtoOrder_Click Me.F_Orders.Product_Catalogue.ProductID = Me.F_Orders.F_Order_line_subform.ProductID...

Thanks GalaxiomAtHome. So is there a way i can update the form? Its basically jsut a transferring exercise. Move all values in my product catalogue form to my order form. Thanks for your help so far!

I populate the fields of one subform by using a combo box, these fields contain product details. Once this data has been obtained i want it to be added to another subform, this is an order subform ready for the products to be ordered. i want to do this by using a button, therefore when a...

Thanks Trevor G! I kind of worked it out myself. I had a hint from my lecturer with the following code. Private Sub GoToProduct_AfterUpdate() If GoToProduct.Value <> "" Then ID.SetFocus '..Set the focus to the field returned by the combo box DoCmd.FindRecord...

Hi Trevor G Thanks for your welcome and reply. Im not sure what you mean when you aks if it is built around a query? I have built the subform using the wizard from an existing table (this contains the list of all the information). 'set the criteria in the query to use the Combo Box, it...

Hey guys, first of all i am a student. I have done some work on databases using Oracle but im completely new to Access so please bare with me. Also im nor sure if im in the right forum but here is my issue. I have a subform called product catalogue. It links to a form that is populated by a...