Fill in Text Box on Form from separate Lookup Form

  • Thread starter Thread starter HeatherM
  • Start date Start date
H

HeatherM

I have a data entry form [frmDataEntry] with a text box
called [SuppNo] There is a button on the form that opens a
separate lookup form [frmSuppLookup] with a subform
[sfrmSuppLookup] which displays a number of suppliers with
similar names displaying two fields [SupplierNo] and
[SupplierName]

Is there any way I can double click an entry in subform
[sfrmSuppLookup] field[SupplierNo] and have the contents
copied to form[frmDataEntry] text box[SuppNo]?
 
Yes.

Write code for the double-click event of the field that has the value in it.

The code would contain lines something like this:

Forms!frmDataEntry.form.SuppNo = me.SupplierNo
 
Thanks Kipp!
Simple and works perfectly

Regards,

Heather
-----Original Message-----
Yes.

Write code for the double-click event of the field that has the value in it.

The code would contain lines something like this:

Forms!frmDataEntry.form.SuppNo = me.SupplierNo

--
Kipp Woodard


I have a data entry form [frmDataEntry] with a text box
called [SuppNo] There is a button on the form that opens a
separate lookup form [frmSuppLookup] with a subform
[sfrmSuppLookup] which displays a number of suppliers with
similar names displaying two fields [SupplierNo] and
[SupplierName]

Is there any way I can double click an entry in subform
[sfrmSuppLookup] field[SupplierNo] and have the contents
copied to form[frmDataEntry] text box[SuppNo]?
Click to expand...


.
Click to expand...
 
Back
Top