Updating records via Form

  • Thread starter Thread starter Nancy
  • Start date Start date
N

Nancy

I have created a form that has controls to either search
or update information on a table. However, if I run a
search, and then try to run an update, I get the error
message "run-time error '3211' ". I have tried the
following:
Me.RecordSource = "Provider"
DoCmd.Close acTable, "TempProv"

the table "TempProv" is the table that is used for
search/update. the table "Provider" is a 'dummy' table

Any suggestions would be appreciated. Thanks :)
 
What does the error message say?


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top