Records/Refresh - Don't Understand What's Happening

[Robert Wetherill via AccessMonster.com]

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

 

[Michel Walsh]

Hi,


.... and the combo box is not used as a navigational tool (code that can be
produced by the button-wizard), to move to a record?


Vanderghast, Access MVP