What event fires when...

[wcboyd]

Hello All,

I have a form that scrolls through the records in the table.
When I click on the "Next" button for the next record what event or events, fires?

 

[gemma-the-husky]

the main event is the form "current event" for the new record

if the old record is dirty there will be

before update/after update events for the form (ie the last record) and maybe the active control/field


there are also mouse events, if you have activated keypresses etc, there may be key events also.

there may be others also

 

[wcboyd]

I think I need to explain what I am trying to do.
I am trying to manually keep a subform in sync because Access seems to be struggling with the fact that the there are five fields that have to be linked.
I think I need to use the "On Current" event as that seems to be firing everytime I hit "next".

But how do I tell it to populate the data into that form...I don't see anything like "RowSource"....

(Just saw your post Dave...thanks for the quick response. Is what I am trying to do make sense or am I making this more difficult that I have to?)

 

[SOS]

Five fields to be linked? That doesn't sound too good. Why are you not linked "primary key" to "foreign key?" Are you using a composite key? How does the subform relate to the main form? The main form and subform should be linked using the Master/Child links and if using the keys (primary on the main side and foreign on the child side) it should work great and insert the keys automatically in the child table when you add a record.

 

[wcboyd]

Yes, this is a composit key. The relationship between parent and child is identifying and actually has a foreign key constraint in the database.

A little more clarity...Access is the front end and Oracle 10g is the backend, using ODBC to connect.

Access "gaks" when I get to the third key pair in the wizard and tells me that they are two different data types. They are not. The are identical: VARCHAR2(256).

I have tried manually linking them using the Parent/Child link fields and it still does not pull in the records from the child.

 

[SOS]

I have tried manually linking them using the Parent/Child link fields and it still does not pull in the records from the child.

Are you using the table or a query for the form recordsources?

Composite keys are a big pain in the @$$ and I never use them. It sounds, however, that you are up a creek because of Oracle (can't stand Oracle myself as they let DBA's get away with really bad design at times - even worse than SQL Server).

So, I'm not sure what to tell you.

 

[wcboyd]

OK. I have figured out a work around to my issue.
I added a button to display the data in a "pop-up" form and then I set the filter criteria and turn on the filter.

Not what I wanted, but it works.

But while I have been working on this I have noticed that the main form will suddenly change the data it is displaying. One moment, everything looks good. Then, all of a sudden, all the fields are populated with "#Deleted".

What is up with that?

 

[SOS]

If you change, add or delete data the form will show that. You might want to hide that form while doing the other, requery the main form (Me.Requery) when you close the other form and make the main form visible again.