Hi all
bit of a confusing one
TBLProductDetails
TBLShippingDetails
I have a form
Main form: FRMProductDetails - RecordSource: ProductDetails
If I have a text box named TXTShippingcode and I want to put the entry into a table that the form isn't a record source for (e.g. ShippingDetails) how do I do this?
I presume I have to do a path from the table name to the table field?, I tried the below into the field record path with no success
[TBLShippingDetails]![ShippingCode]
bit of a confusing one
TBLProductDetails
TBLShippingDetails
I have a form
Main form: FRMProductDetails - RecordSource: ProductDetails
If I have a text box named TXTShippingcode and I want to put the entry into a table that the form isn't a record source for (e.g. ShippingDetails) how do I do this?
I presume I have to do a path from the table name to the table field?, I tried the below into the field record path with no success
[TBLShippingDetails]![ShippingCode]