Reference a nested subform textbox

[JimN]

What is the correct reference for a nested subform's textbox? I have a form
that has 2 textboxes in a nested subform. The 1st textbox, "BarCode" is
populated when a barcode scanner inputs a number into the "BarCode" textbox
and the 2nd textbox, "ItemDescription" needs to be populated with a "Parts",
table's,"ItemDescription" field. The table "Parts" has a "BarCode" field
which contains the barcode number assign to a part. When a barcode is scanned
into the nested suform's "BarCode" textbox, a parameter pop-up box asks for
the value of the nested suform's "BarCode" textbox. This nested
subform's"Barcde" field is referenced in an OnChange event procedure for the
nested subform's "BarCode" textbox. In the event procedure, the nested
subform's "ItemDecription" textbox is equal to the table's "ItemDescription"
field, where the table's "BarCode" field is equal to the nested subform's
scanned "BarCode" field . The reference to the nested subform's "BarCode"
field must be incorrect.

 

[Roger Carlson]

Take a look at my website (www.rogersaccesslibrary.com). On it you will
find a small sample database called "SubformReference.mdb" which shows how
to reference a variety of things on subforms and subsubforms.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L