Controls in forms

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

How do I add a control button that will open another form in "add" mode
rather than edit?
 
How do I add a control button that will open another form in "add" mode
rather than edit?
Click to expand...

Set the Click event of the command button to:

DoCmd.OpenForm "FormName", , , , acFormAdd
 
All it did was come up with a message that it couldn't find the object 'DoCmd'
Click to expand...

That offers us no help at all.
Did you change "FormName" to whatever your actual form name is?
Please copy and paste the full exact click event code into a reply
message.
 
Bill said:
Here is what I typed DoCmd.OpenForm "Tenants Move In". . . .acFormAdd
Click to expand...


I see you have periods instead of commas. That would certainly be an error.

Did you type that directly into the button's On Click event property (that
would be an error), or did you create an event procedure and put this line
of code inside that event procedure (that would be the right way to do it)?
 
Here is what I typed DoCmd.OpenForm "Tenants Move In". . . .acFormAdd
Click to expand...

That's not what I suggested.
You have used dots in place of commas.
The correct syntax is:
DoCmd.OpenForm "FormName", , , , acFormAdd

That's 4 commas after "FormName"
Look up, in VBA help, the OpenForm method for the correct syntax.
 
Linq Adams via AccessMonster.com said:
"All it did was come up with a message that it couldn't find the object
'DoCmd'"

Making the mistake with using periods instead of commas should have popped
up
a "syntax error" message, but I don't think Access ever got that far!

Access stating it "couldn't find the object 'DoCmd'" suggests to me that
the
OP probably has a missing reference that causing Access to error out.
Click to expand...


If Bill put the statement directly into the On Click property of the command
button, then clicking the button would give the error message "<database
name> can't find the macro 'DoCmd.'" My guess is that this is what has
happened.
 
Back
Top