Find record in external non-source table based on text box

[mckenneyj]

Form source is tblXYZ
Storage field is ConfID

external source tblConfInfo with matching field name ConfID
and serval other currency fields "amtdue", "discount", "firsttime", etc...

ex: tblConfInfo
amtdue = 50.00
discount = 20.00
firsttime = 5.00

Button on form named btnCalc with underlying code.

Code should look at me.ConfId and locate corrsponding record in tblConfInfo.ConfId and create a recordset with the currency fields so I can use them in calculations in the same sub.

Thanks,
John McKenney
Work Hard... Play Harder

 

[PHV]

And what have you so far ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[mckenneyj]

Unfortunately nothing as everything tried so far bombs out.

Thanks,
John McKenney
Work Hard... Play Harder

 

[PHV]

And which sort of code bombs out ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[mckenneyj]

I have tried setting the recordset for the control
to be something other than the recordset of the form

Thanks,
John McKenney
Work Hard... Play Harder

 

[PHV]

the recordset for the control
???
Which control ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[mckenneyj]

please disregard

Thanks,
John McKenney
Work Hard... Play Harder