Search form not Blank

gsbatch1

Registered User.
Local time
Today, 11:40
Joined
Dec 28, 2010
Messages
45
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?
 
In the Load event:
Code:
DoCmd.RunCommand acCmdRecordsGoToNew
 
Nope I am getting

Run-time error '2046':

The command or action 'RecordsGoToNew' isn't available now.
 
Oops... I meant, put that code line right after the OpenForm code line.
 
Still not responding correctly.

I attached a copy for you to look at.
 

Attachments

Still not responding in what way? Is it displaying an error?
 
What form should I be looking at? And what button opens the other form?
 
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.
 
I'm talking about your attachment. What form is it? And what button are you having problems with?
 
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.
 
You set the AllowEdits property of your form to NO.

And they should populate with what? Their Default Values?
 
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.
 

Users who are viewing this thread

Back
Top Bottom