Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Find Out Last Record in a subfrom that user entered

Status
Not open for further replies.

matrixtech

Programmer
Dec 3, 2001
12
US
Hello,

I currently have a form, "FormA" that has info about a consultant's
assignment at a company. There is a subform "subFormA" in datasheet view,
which lists each day the consultant worked and how many hours he/she worked.

If the user clicks a button on FormA, subFormA is automatically populated
with a record containing the date for each remaining day of the current
year. In other words, on jan 1, there would be 364 records entered each with
a date.

Now, lets say the user decides to enter the date and hours of one record.
The button has not been pushed so there is only 1 record showing. Then, the
user pushes the button adding a record for each day left in the year. How
can I get the cursor to return to the day after the last user entry? In
other words, allow the user to continue entering data where they left off.

Any help would be greatly appreciated.


Geoff

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top