PC Review


Reply
Thread Tools Rate Thread

Clearing fields from a form...

 
 
=?Utf-8?B?ZGNhc2g0NQ==?=
Guest
Posts: n/a
 
      29th Jun 2006
Hi Im trying to clear the fields on my form which I used a query to design
this form. I took 3 of my tables in put in a query to join them together has
one. The thing Im trying to do is clear all the fields, but Im getting back
some error. I tried Access own wizard clear function…which was…..

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

But I got this error in return….

The command or action 'SaveRecord' isn't available now.

I tried to write the code to clear each fields to this…..

Me.LastName.Value = Null or Me.LastName.Value = “”

But I got this error in return….

This recordset is not updateable


So can anyone help me out in trying to clear a form and let me know what Im
doing wrong?

Thank you,

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Clearing Fields from a Form =?Utf-8?B?RGFudQ==?= Microsoft Access Forms 8 28th Mar 2007 06:24 PM
Clearing Unbound Fields In Form =?Utf-8?B?U2NvdHRT?= Microsoft Access Form Coding 2 26th Feb 2007 03:41 PM
Clearing fields on a form =?Utf-8?B?bWpqNGdvbGY=?= Microsoft Access Form Coding 1 22nd Mar 2006 03:36 PM
Clearing Fields In A Form =?Utf-8?B?UGF1bEh1bW1lbA==?= Microsoft Word Document Management 2 15th Jun 2005 04:09 PM
Clearing fields on a Form MichaelR Microsoft Access Form Coding 2 12th Sep 2003 11:44 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:05 PM.