Can't get field to populate after calling qry (1 Viewer)

Waxmann

New member
Local time
Today, 11:51
Joined
Aug 18, 2020
Messages
26
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

I’m here to help
Staff member
Local time
Today, 10:51
Joined
Oct 29, 2018
Messages
19,136
Maybe your form has moved to a new record?
 

Waxmann

New member
Local time
Today, 11:51
Joined
Aug 18, 2020
Messages
26
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

Super Moderator
Staff member
Local time
Today, 13:51
Joined
Feb 19, 2002
Messages
36,837
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.
 

Users who are viewing this thread

Top Bottom