Moving between subforms after adding records

[umair434]

Hi,

I have a main form!

The main form is used to enter data - This main form has 4 subforms where each subform represents a report. So the user logs in (I use date() function to get the today's date) and he enters the data - Sometimes the user might want to enter data for 2 reports (using 2 subforms) on the same date!

when that happens, my main table show multiple records for the same date - For exampel

Date ....Report 1 ....Report 2

1/1/2007 ...24
1/1/2007....................38



Also, multiple users will be using this application on the same day so date will not be unique - but how can I make it unique for each user?

hope i'm making some sense. thanks!!!

 

[G37Sam]

I don't see where the problem is, perhaps I misunderstood you

 

[umair434]

The issue is that a user might have to enter data in 2 subforms on the same date. When this happens, I want only 1 record showing that User has entered numbers in report 1 and report 2 -

Right now a new record is added when user adds data to any other subform even though its on the same date.

thanks!

 

[G37Sam]

Ok I think I have a clearer picture

You want the user to add a new record the first time, but then edit that record the second time rather than add another one?