parent form Barcode value transferring to subform in POS

**Raveen1609** · 06-30-2023, 12:32 PM

Hi, I have a small POS. Main form with a subform to add products. I use a field in the main form to read the barcode. I have used DLookup and got the product name Value. Now how can I insert this Product name value to the ProductName field in a new record in subform. Kindly suggest.

**Welshgasman** · 06-30-2023, 12:53 PM

Just set the control?
http://access.mvps.org/access/forms/frm0031.htm

**June7** · 06-30-2023, 07:52 PM

Why save product name to related child record - this sounds like duplicating data between tables. Why not just ProductID?

**Raveen1609** · 07-01-2023, 01:03 PM

Thanks. I don't understand how to do that coding for that, I have product ID.

**June7** · 07-01-2023, 02:34 PM

What is primary key field of main form/table? That is the value that should be saved to subform/table. If Master/Child properties are correctly set, this should happen automatically.

If you want to provide db for analysis, follow instructions at bottom of my post.

parent form Barcode value transferring to subform in POS

Thread Tools

parent form Barcode value transferring to subform in POS

Similar Threads

Getting from a subform to a parent form button_Click

Saving a Parent form, while a relational subform is open on the Parent form.

Calling a control from one subform into another subform that do not share the same Parent form

Transferring (other than bound) value of a multi-column combobox on subform to combobox on main form

Transferring Latest Entry from Subform to Field in Main form on Load

Posting Permissions