Subforms with Access Projects

[BobJacksonNCI]

If someone out there in Tek-Tips land has created Forms/Subforms using tables on an SQL Server, I could surely use your expertise and experience!
I'm using Access 2000 and SQL 7.

I suspect most of the difficulties I'm having are related to Access Project because I can do equivalent things in plain Access without the frustration. So, while I appreciate all responses, I'm thinking that folks "who have been there" may understand what/why/how better.

Following threads are related to the database I'm creating and document the trials... My immediate issue was visited before in one of the threads. When navigating on the main form by advancing through existing records, all is right until passing the last record. Upon changing gears to add a new record, the subform displays the record(s) associated with the last existing form.

thread702-678908

Thread702-676244

thread958-624720

thread702-623415

thread958-613752


HTH,
Bob
Your mileage may vary, but following the guidelines in faq181-2886 will help you reach your goal.

 

[BobJacksonNCI]

Hmmm,

No responses...

I understand - since I'm having this much trouble I should hire someone.

But I can't.

Immediate issue is documented in thread958-624720

The problem exists when the recordset is used and goes away when the recordset is commented out - which also eliminates the current record number and record count.

code:

Dim rst As ADODB.Recordset
Set rst = Me.Recordset

lines of code prefilling current form using data
displayed on previous employee selection form
that remains open, but is overlayed

txtCurrRec = Form_frm_TIME_OFF.CurrentRecord
txtNbrRcds = rst.RecordCount
Set rst = Nothing

Can anyone assist?

 

[BobJacksonNCI]

The solution to my immediate issue is just to add an AfterUpdate event to the subform and put Me.Requery in it.

Seems basic enough, and I'm sure some folks reading this are now convinced that I'm in the wrong field...

However, I did a lot of looking through event sequences for forms and subforms before figuring it out.