I've got a form designed to add new records, but when it pops up, it 

brings the first record in the db. That's fine & well for the view only 

form, but this one I need to pop up with a new, empty form ready for 

entry. I thought I was doing that, but found I was just blanking the first 

record which isn't good. 



Thanks!!!



Sean

Goto the Properties for the form, and change "Data Entry" to YES.



That will fix it for you.





-----Original Message-----

From: Sea [mailto:sean_stonehart@u...]

Sent: Monday 13 August 2001 14:33

To: Access

Subject: [access] Getting an "add Form" to load with an empty record





I've got a form designed to add new records, but when it pops up, it

brings the first record in the db. That's fine & well for the view only

form, but this one I need to pop up with a new, empty form ready for

entry. I thought I was doing that, but found I was just blanking the first

record which isn't good.



Thanks!!!



Sean

Hi Sean,



Refer to 'OpenForm Method' in Access help and make sure you set datamode 

to acFormAdd when you open the popup form.  For example;



DoCmd.OpenForm "Employees", , , , acFormAdd



John



_____________________________________



John Fejsa

Systems Analyst/Computer Programmer