Access 2007 - Events not firing in tabbed subform

[mtevans5]

Hi,
I'm trying to fix a form in Access 2007 and I'm having a of a time.

The form has a Main form and two subforms. The main form has a three tab setup with two of the subforms on tab 2 and three respectively.

The first subform is an input for a single record into a table.
The second subform is a datasheet view of all the records from that same table.

I need to get the datasheet subform to display all of the records when the tab is clicked on including the new record just created in the first subform.

I have created refresh macros and written refresh commands in VBA but I can't get anything to fire. I tested with simple messages in all events that should trigger when the second subform is clicked on and nothing is firing.

There are no filters on the records.

Does anyone have any idea why these events would not fire?

I have tried:

OnFocus
BeforeUpdate
OnClick
OnEnter
OnLoad

Nothing is executing the requery.

Help! I'm about to throw this entire program and Access 2007 out the window!

Thanks,
Maureen

 

[boblarson]

Have you done this yet?
http://www.btabdevelopment.com/main...owtoenablecodeandmacros/tabid/57/Default.aspx

 

[mtevans5]

Thank you so much! That was the exact issue. This was my first action in Access 2007 and I didn't know about the Trusted Locations.

Thank you again!

 

[db_john]

I have similar but a little bit different problem and when I do the search, I find this post.

My main form has 4 tabs each of them has a subform. Problem happens on tab #1. The main form displays client's major details and 1 subform displays contact person data from another table which has the clientID as the indirect link. Both the main form and subform has the Access navigation button enabled.

The reason for the "indirect" link is a client may have more than 1 contact persons and a person may be contact of more than 1 client. Also the position of a contact person may be different in each client. Therefore I use another table called ContactLinks which has 3 fields: ClientID, ContacID and Position.

As I want user can edit the data directly in the subform, I set the RecordSource of the subform directly to the Contacts table. But the Position text box is an unbound object. How can I update the Position text box to get the position of this contact person in the displaying client? Also, if the client has more than 1 contact, when I click the contact subform to display another contact.

I think if there is an event triggered when I click the subform navigation button, I can add codes to search the ContactLink table to get the position.

Thanks for your help.