Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.
Solved
add new record on a other open form with vba on microsoft access 2013
Posted on 2014-02-11
hi
i can two forms open for expamle the names are form1 and form2
and i wan't when i press on some button in form2 it's will set the focus on form1 in a new record by the field form1!Id
something like this
DoCmd.GoToRecord (on form1) , , acNewRec
DoCmd.GoToControl ("form1!InvoiceNum")
i can two forms open for expamle the names are form1 and form2
and i wan't when i press on some button in form2 it's will set the focus on form1 in a new record by the field form1!Id
something like this
DoCmd.GoToRecord (on form1) , , acNewRec
DoCmd.GoToControl ("form1!InvoiceNum")
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
3 Comments
Hello Bill201,
Try these codes:
DoCmd.GoToRecord acDataForm, "form1", acNewRec
Forms!form1.SetFocus
Forms!form1!InvoiceNum.Set
Sincerely,
Ed
Try these codes:
DoCmd.GoToRecord acDataForm, "form1", acNewRec
Forms!form1.SetFocus
Forms!form1!InvoiceNum.Set
Sincerely,
Ed
thanks alot for your answer but i get an error message after the first line (it's a sub form so it's look like this :
DoCmd.GoToRecord acDataForm, "Forms!form1parent!form1ch
and i get an error message like this "run time error 2489 the object "Forms!form1parent!form1ch
DoCmd.GoToRecord acDataForm, "Forms!form1parent!form1ch
and i get an error message like this "run time error 2489 the object "Forms!form1parent!form1ch
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string.
Specify the first argument, which is the expression to be returned:
Specify the second argument, which …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses
Course of the Month10 days, 1 hour left to enroll
722 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.