Microsoft Access Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community Forums > Databases > Microsoft Access Development
Reload this Page

Open form and show no record

Discuss Open form and show no record in the Microsoft Access Development forum on Dev Articles.
Open form and show no record Microsoft Access Development forum to discuss problems and solutions with this popular DBMS. Use Access to build and modify database tables, or full-featured applications.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old October 27th, 2004, 04:03 PM
trucktime trucktime is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Oct 2004
Posts: 6 trucktime User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Question Open form and show no record
When I open a form it shows the contents of a record, I want to open it and show just empty fields, which I can fill out to create a new record.
How can I do that? Thanks. Trucktime
Reply With Quote
  #2  
Old October 27th, 2004, 04:48 PM
lwells lwells is offline
Contributing User
Dev Articles Novice (500 - 999 posts)
  
Join Date: Sep 2004
Posts: 632 lwells User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 Day 21 h 59 m 38 sec
Reputation Power: 4
Set the forms property Data Entry to Yes. Then when you open the form it will be empty for a new record.

See if that helps you,
lwells
Reply With Quote
  #3  
Old October 27th, 2004, 05:43 PM
trucktime trucktime is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Oct 2004
Posts: 6 trucktime User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Thumbs up It works
Thanks IWells, it works.
Trucktime
Reply With Quote
  #4  
Old November 10th, 2004, 01:41 PM
sgray74 sgray74 is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Nov 2004
Posts: 4 sgray74 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 5 m 17 sec
Reputation Power: 0
You could also do it through code if you want to....

Use this in the onclick event procedure from a command button........

DoCmd.OpenForm "YOURFORMNAME", acNormal
DoCmd.GoToRecord , , acNewRec
Reply With Quote
Reply

Viewing: Dev Articles Community Forums > Databases > Microsoft Access Development > Open form and show no record

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
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
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 5 hosted by Hostway.