473,401 Members | 2,146 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,401 software developers and data experts.

How to input and save data and continue adding record in multi page form?

Using Access 2007, I have a simple application consisting of two forms with a nbrID numeric (non-auto) primary key. These forms basically capture donation information and update a donor database. My question is: How can I, using a simple command button to save updated information on FormA, then go to FormB with the same current donor record to continue data entry on the current record?

As it is now, FormB defaults to the first database record whereby we have to manually go down to the current record to continue our data entry. I'm a little more familiar with macro solutions v.s. VBA solutions. I think I just need to enhance my macro that advances FormA to FormB but I don't know how to maintain the current record. Thanks!
Jan 24 '11 #1
1 1945
RuralGuy
375 Expert 256MB
You may find this solution useful: http://www.baldyweb.com/wherecondition.htm
Jan 24 '11 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Michelle Marie | last post by:
I have several forms stored in pdf format. Instead of scanning these forms and using them in reports, I would like to create a background in an access report to place the fields but have it...
44
by: bloukopkoggelmander | last post by:
Hi all I am about to go mental on this side. All I want to do is to have a form where the user can enter/edit/delete a new/exisiting record and use Access's built in record navigation at the...
5
by: Hollywood | last post by:
Good day dear members of the comp.databases.ms-access newsgroup. Please I need your help on the following. I'm the administrator of an Access 2007 database. I would like my enterprise personnel...
5
by: ARC | last post by:
Hello all, I had this e-mail today from a user, and would like to get some ideas to pass along. Many thanks, all! Andy " my program is very very slow when more than two people are using the...
3
by: musicloverlch | last post by:
I am in a new position and looking at the possibility of using Sharepoint for my database instead of the whole backend on the server, frontend on the workstations route. Does anyone have websites...
1
by: Mientje | last post by:
I've made an Access 2007 database to store information about the lessonplans I have to make every schoolyear. I want to export the data form the table "Lesvoorbereiding" (Lessonplans in English) to...
3
by: brat33 | last post by:
I am trying to use a command button to automate a process for creating mailing labels from a query in Access 2007, going into word 2007. Current code looks like the following: 'Start MS Word Dim...
1
by: JMANTN | last post by:
I have data that sometimes needs to be uploaded to a 3rd party website and I’m trying to automate this process with Access 2007. I’m having a difficult time with my VBA syntax and with identifying...
0
by: cmcsween | last post by:
Will the Access 2007 runtime version run on machines with Windows 95, 98, and/or 2000 as the OS? Carol
2
by: Michael Burke | last post by:
Access 2007 Query - how to open forms in Datasheet View rather than Form View on a Switchboard. I need to change the code in the code element named "HandleButtenClick" Yet I cannot find this code...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.