I am having a tonne of trouble opening a from through a button or otherwise and lin king it to a certain field.
it seems to only want to do it if the next form has the same source (e.g tblCustomer)...
it doesn't work if i use two forms from two different sources but have the same fields, usually from a query for example.
doesn't seem to work...
I need it to read what the CustomerID is from a from... remember it... then open the next form up with the same CustomerID,
the next form will hold an OrderID, so uses a different table (tblOrder) which has the CustomerID in and theyre linked in a relationship.
so the button will then remember the OrderID, and open the next form relavent to that, no matter what the form source is.
Im thinking something like
(which to me this reads... in this next form, the customerID equals the form "frm001"'s customerID.) frm001 is the form for the customer stuff, opening form frm002 which holds order stuff... which will open frm003 which holds order details etc...
it seems to only want to do it if the next form has the same source (e.g tblCustomer)...
it doesn't work if i use two forms from two different sources but have the same fields, usually from a query for example.
Code:
"[CustomerID]=" & [CustomerID]
I need it to read what the CustomerID is from a from... remember it... then open the next form up with the same CustomerID,
the next form will hold an OrderID, so uses a different table (tblOrder) which has the CustomerID in and theyre linked in a relationship.
so the button will then remember the OrderID, and open the next form relavent to that, no matter what the form source is.
Im thinking something like
Code:
"[CustomerID]=" &[Forms]![frm001].[CustomerID]
(which to me this reads... in this next form, the customerID equals the form "frm001"'s customerID.) frm001 is the form for the customer stuff, opening form frm002 which holds order stuff... which will open frm003 which holds order details etc...