Data Entry Form on Top / Continuous Form on Bottom

[jvol]

Hi there,
I am having some trouble making my data entry form work correctly. I've created a form that contains two subforms.

1.The top form contains a combobox, timestamp and notes field as well as a save/create new record button. -This is a single record form used for data entry.

2. The bottom form contains the same fields as the top but is set up as a continuous form to show all of the records.

3. I would like the bottom form to show new additions in real time, without having to manually refresh the page every time, or close the form and reopen it.

I've attached a sample database as a reference. I would really appreciate some help on this. Thanks in advance!

 

[pbaldy]

Can't open the sample right now, but try requerying the bottom form from the after update event of the top form.

 

[jvol]

Hi Paul,

I'm not quite sure how to do that.. I'm pretty new to Access so please bear with me..

My top form is called frmTimeStampNew. Bottom form is called frmTimeStampAll. The main form containing these two forms is called frmTimeStampTask.

If I go into the after update property of frmTimeStampNew and add the macro "requery" it asks for a Control Name. I've tried adding frmTimeStampAll. But that doesnt seam to work.. could you spell out the details?

Thanks so much for your help!

J

 

[pbaldy]

I don't use macros, but see if this helps:

http://access.mvps.org/access/forms/frm0031.htm

 

[jvol]

Thanks, but I don't really follow the chart.. how would you go about accomplishing this?

 

[JHB]

As pbaldy wrote - requery the bottom form from the after update event of the top form.
Database attached.

 

[jvol]

Thanks so much! This is exactly what I was looking for!

 

[JHB]

You're welcome.

 

[jvol]

Hey guys, I'm running into another issue with this form.

I initially intended that frmTimeStampTask would sit inside of a job record. There will be multiple jobs, each with its own frmTimeStampTask subform. The records in any particular job should only relate to that job, not to all timestamp records.

Please see the attached example. I created a one-to-many relationship that only includes records that are the same between the JobNo fields in tblJobInfo and tblTimeStamp.

frmJob contains a tab control with frmTimeStampTask embedded as a subform.

How can I make it so that the user only sees TimeStamps for the job record being shown? For example only the time stamps for job 123. Or only the timestamps for job 321.

Thanks so much for your help.. you guys are amazing

 

[JHB]

Try it now.

 

[jvol]

Wow this is great! So you didn't need frmTimeStampTask at all? Both subforms are sitting inside of frmJob.. Will this still work if I put the subforms inside of a tab control? The final version will have a couple other time trackers in different tabs.

 

[JHB]

Will this still work if I put the subforms inside of a tab control?

Short answer - Yes.