Can't get field to populate after calling qry

[Waxmann]

I have a frmScan that has 2 fields. One is a txt.description - control source is tblPrtChoice.Description
The second is me.txtscan and is looking for operator input that triggers a qry to run and print a label (quick screen says printing) then returns to the frmScan.

The problem is that when it returns the focus is correct - me.txtscan, but txt.description is now blank. I can't get it to populate from the tblPrtChoice.Description. Any suggestions would be appreciated, thanks

 

[theDBguy]

Maybe your form has moved to a new record?

 

[Waxmann]

Don't think so. Now the form is working as expected. I inserted me.refresh, me.requery in a bunch of places. I think I fixed it but don't know how!!

 

[Pat Hartman]

Do you know what the "re" 's do? Requery, Refresh, Repaint, Recalc. You should look them up rather than using them indiscriminately. Two of them save the current record before they do their intended action.