Subform works correctly on its own, but on initial form not working

[pmathobela]

Hi All,

For the past 6 hrs trying to solve this problem but I am failing. I have a subform called Interview_Subform, that works very fine, and when it calls the form Interview it still does what its suppose to do.

This subform is on the form called Employee. Here its where it gives me a problem. I have tried changing properties but still its not working.

please refer to the attachement for more info...

Can someone please help me on this...

Thanx guys,Phala.

 

[sandy2011]

is the data in the query behind the form?
check 1. table
check 2. query
check 3. form
check 4. relationships between tables relating to form... (cascade update fields are clicked on relationship)?

 

[boblarson]

(cascade update fields are clicked on relationship)?

Sandy - it is RARE to actually need the Cascade Update checkbox checked. I'm not sure you understand what Cascade Updates really do. If you have a primary key and let's say it is text (which I wouldn't use but some do) and it is a name of a business (also a bad design choice but it does happen). And that business changes its name slightly. So, you have all of these records with the PK of the business' old name and you need to change it. Cascade updates allows you to change the PK and it will automatically update the old values with the new ones FOR THE PRIMARY KEY ONLY. It makes no changes to any other data. It is only if the primary key changes.

Now, if you choose something, like say an autonumber (surrogate key) then you are not going to ever need this.

 

[boblarson]

1. It looks like the form in the subform is either not linked properly or it is set to DATA ENTRY = YES.

2. If it is linked properly to the main form then you should be able to requery the subform upon close of the entry form and it should display.

 

[pmathobela]

Hi Bob,

I have checked on the property sheet for the subform on but could not get the "DATA ENTRY" you are talking about. Where do I get this?

Thanx

 

[missinglinq]

Opening the Form the Subform is based on, in Design View, go to Properties - Data and make sure that Data Entry is set to No.

Linq ;0)>

 

[pmathobela]

Hi missinglinq,

Thanx, but the property is already set to NO.

 

[pmathobela]

Any help guys???? The 'DATA' property was already set to 'NO'

 

[boblarson]

I could tell you why if I could look at a copy of the database.

 

[pmathobela]

Hi Bob,

Unable to attach as a zipped database more than 2.00 MB. Its 2.2MB

 

[boblarson]

Hi Bob,

Unable to attach as a zipped database more than 2.00 MB. Its 2.2MB

Did you remember to run Compact and Repair BEFORE zipping it?

 

[pmathobela]

Hi Bob,

Didnt know about that. Thanks just learned something new today! Anyway I have run it and attached please find the database.

Regards,

 

[pmathobela]

Hi Bob,

Still looking at the Database?