Records/Refresh-What happens behind this event?
- Hello all,I am working on someone else's form that has several
combo boxes and text boxes. In this example, there are
four tables, "table_A" , "table_B" , "table_C" and "table_D" .
We will call the form "form_A"
There is no pertinent VB Code.
The record source listed is "table_A"
The control sources for the objects in the form come from fields in "table_A"
When I run the form, I click the >* at the bottom in
order create a new record. I then get focus on Combo Box "combo_A"
For object "combo_A" ,
the Row Source Type is Table/Query
the Row Source is a Query, we will call is "query_A"
"query_A" is a join between the other three tables, and returns only one
field, the customer name.
At this point I select "Records/Refresh"
So what the h@#!ell happens at this point? All my text boxes are getting
filled with data
which I think is coming from "query_A", even though only one field is
returned in the
query. How can I determine what is happening behind the "Records/Refresh"
command?
Any help would be greatly appreciated!
Thanks
-
You can trace it out via SQL Profiler to see what was passed back to the database. That will cover the code that hits the DB. For anything else, like client side code that might be re-loading data without going to the DB, you would need to log the actions from the client code.
-
Thanks,
How do I use SQL Profiler?
-
Thanks for the help! Problem solved! I am working with someone else's form and DID NOT think the former developer knew enough SQL to create TRIGGERS.
Faah' reakin' TRIGGERS! I should have looked there first, assumed nothing was there. So now I know what to do.
Many Thanks,
Urwethe
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply