New record in form help 1

[sparkyout]

I have [frmCustomers] which displays companies and addresses.

A user can create new "RGA number(s)" for a company via [frmNewRGA]. They can access the form via a control button where I used the wizard to "open form' [frmNewRGA]

Here's my problem. When [frmNewRGA] opens it shows all the records specific for each company. I want the fields to be empty for a new record. [RGAid] is an autonumber. Users can view all "RGA numbers" on [frmCustomers].

How do I set [frmNewRGA] to be blank once opened via the control button on [frmCustomers], so users can create a new RGA number?

 

[quietstormtw]

Hey Sparky,

If you are going to open the form in this manner...I would suggest creating a macro that will open the form in add mode. Then delete the button that you've already created - create another button, using the wizard and attach it to the macro.

Good Luck

 

[RoyVidar]

Hi!

One thing to try, is using the datamode argument of the openform method:

[tt]docmd.openform,,,,acformadd[/tt]

Else, you could try setting the DataEntry property of the form to Yes.

Roy-Vidar

 

[sparkyout]

Roy,

I set data entry to "Yes" and it worked like a charm. Thanks so much. Wish I spent less time on this and posted sooner.
-Kim