Search form not Blank

[gsbatch1]

I want ot be able to open a form that a tech can use to search for and update records. The initial opening should have all fields blanked out until the acocutn number is entered in. I can not get the form to open with the fields blank.

I have used DoCmd.GoToRecord acDataForm, , acNewRec
I have tried to use all the fields set to Default Null

How do I have the initial form load show all the fields blank?

 

[vbaInet]

In the Load event:

DoCmd.RunCommand acCmdRecordsGoToNew

 

[gsbatch1]

Nope I am getting

Run-time error '2046':

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

 

[vbaInet]

Oops... I meant, put that code line right after the OpenForm code line.

 

[gsbatch1]

Still not responding correctly.

I attached a copy for you to look at.

 

[vbaInet]

Still not responding in what way? Is it displaying an error?

 

[gsbatch1]

Sorry same error, just different place now.

 

[vbaInet]

What form should I be looking at? And what button opens the other form?

 

[gsbatch1]

I have not created the main (Switchboard) yet. They just asked me to add the update form. Originally I packaged the entire thing into a runtime pkg. It opened up directly to the XHSDispTool form.

Now I am going to create the Main form as a switchboard allow for a choice between Data entry and Data update.

 

[vbaInet]

I'm talking about your attachment. What form is it? And what button are you having problems with?

 

[gsbatch1]

Im just trying to get the frmXHSUpdate form to open correctly right now. I have not created a button for it yet. I was trying to make sure that the form was correct and then I would create the button to open it.

When I dbl click that form, I want it too open with all the fields blank. They should populate when the acct number is entered in the Account# field in the Header section.

 

[vbaInet]

You set the AllowEdits property of your form to NO.

And they should populate with what? Their Default Values?

 

[gsbatch1]

Like I said. I tried everything. I set all default to Null hoping that would fix the issue. I must have missed the setting for allowing edits.

 

[vbaInet]

Well, now you know so you can test and it should work.