Problem inserting info into a field of a table
Problem inserting info into a field of a table
(OP)
I've recently returned to work from sick leave and think that my brain is still off.
I have a form that has a field called Coding. Users select the "Leader" and the Coding gets displayed on the form. My problem comes when I try to update tblResults. The Coding field is blank. When I close the form I have tried Me.Dirty-"False". I have also tried DoCmd acSaveRecord. Neither one works.
On the form the Coding appears as soon as the LeaderID is selected. All that I want is for the Coding to appear in the table.
Any suggestions? Thanks
I have a form that has a field called Coding. Users select the "Leader" and the Coding gets displayed on the form. My problem comes when I try to update tblResults. The Coding field is blank. When I close the form I have tried Me.Dirty-"False". I have also tried DoCmd acSaveRecord. Neither one works.
On the form the Coding appears as soon as the LeaderID is selected. All that I want is for the Coding to appear in the table.
Any suggestions? Thanks
RE: Problem inserting info into a field of a table
Hope This Helps, PH.
FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?
RE: Problem inserting info into a field of a table
RE: Problem inserting info into a field of a table