Search results

Thanx - I will check out the link. Btw - Finding the first instance of the form was the intended functionality. I think I introduced some confusion on this issue by bringing up the multiple instances of the form in the first place. I had mistakenly attributed the issue to the fact that I was...

Thanx for your observations and time. I'll move past this issue and live with the limitation. Fran

Galaxiom - Thanks for the reply I have tried setting focus to the object - you'll notice in the code I posted I'm iterating through the forms collection and using the index value when setting focus. Additionally I tried declaring a variable as form setting it to the object in the forms...

I've attached a db with the identified behavior It seems the real problem is difficulty Setting Focus to forms with the Default View of:Split Forms. The code to works fine for forms with the Default View of: Single Form On the Projects List screen there are 2 command buttons Contract...

Ok ill have to make one tonight. Thank you

Does anyone have some input or does this one go unsolved?

Thank you Old Man Devin. I do now see how a nested sub form would be appropriate in the scenario you described and will give one a go.

I was hoping someone could give me a practical example of a Nested SubForm. I use the SubForm control extensively in my application but always only 1 level down when I'm presenting a 1 to many relationship. Such as an Invoice or Sales Order. With the main form representing the "Header"...

I can't figure out how to set focus to a non Default instance of a form. Environment A2007 ADP Project Document Window Option - Tabbed Documents MS SQL 2012 Express DB Windows 7 64 Bit I using Allen Browne's method to open more that one version of form, storing each form object in a collection...

Hi Sarah, I took a quick look at your database, relationship and forms. I came up with a couple of issues why you could not add a JobSheet Record through your form. frmJobSheet 1. Primary reason for not being able to add a record was your form did not have a field for OpenedBy - while the...

Hi Kathy Did you solve your last issue? Based on what I see - you are missing a key table - Shipments or Orders this table would represent the shipment event. The customer and employee fields would be in this record. Your transaction table would be the details to that event with a separate...

Hi all - my name is Fran and I just joined this group. I am currently a home improvement contractor but have over 20 years experience in system design, development and implementation. My only current use of access is a business management - ERP system I developed to manage my business. It is...