How do I create a recordset with the criteria being the primary key on an open form?
eg form is open with numeric field chargeID
rstTemp.openrecordset("select * from tblChargeProduct where ((tblChargeProduct.ChargeID)=[Forms]![frmCharge]![ChargeID])
This looks like it should work to me. Can it be done??
I am also wondering if I can get the recordset.findfirst function to operate with a numeric field. Can't seem to get that to happen either. Any assistance would be greatly appreciated.
eg form is open with numeric field chargeID
rstTemp.openrecordset("select * from tblChargeProduct where ((tblChargeProduct.ChargeID)=[Forms]![frmCharge]![ChargeID])
This looks like it should work to me. Can it be done??
I am also wondering if I can get the recordset.findfirst function to operate with a numeric field. Can't seem to get that to happen either. Any assistance would be greatly appreciated.